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
ServerParameters
- _queryResult
- Type: QueryRun Class
The query run object.
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: