AuditPolicyExecutionTask.buildAggregateDuplicateSamplingQuery Method [AX 2012]

Builds a query that selects each root document record that violated the aggregate, duplicate, or sampling audit rule.

private Query buildAggregateDuplicateSamplingQuery(QueryRun _queryResult)

Run On

Server

Parameters

_queryResult
Type: QueryRun Class
The query run object.

Return Value

Type: Query Class
The query that was built.

The query is primarily built to get each record that comprises the group by the record that is returned by the original query.

Since such a record does not contain the root table record IDs, we must re-create the query without the group-by clause and add that clause as a range onto the new select query. By doing this we receive all the records that were grouped by the original query.

Community Additions

ADD
Show: