Question 470
At fictional Xenon Office Supply, the Business Central development team is supporting office stock replenishment and reviewing object model and application extensibility during a sandbox design review (MB820-3.6-115). The observed development issue is that a query has an aggregation column but the grouping fields create one group per unique transaction. Which AL development or design response most directly addresses this issue?
Explanation
Correct Answer
The most direct corrective response is to review grouping columns and Sum/Count aggregation placement. This addresses the specific failure where a query has an aggregation column but the grouping fields create one group per unique transaction. Acceptance evidence is that the query returns one summarized row per desired customer period.
Incorrect Answers
“Use a query object with an appropriate aggregation method and grouping columns” supports the separate task “use a query object with an appropriate aggregation method and grouping columns”, not the reported problem: a query has an aggregation column but the grouping fields create one group per unique transaction. This case instead calls for “review grouping columns and Sum/Count aggregation placement”.
“Reevaluate grouping and totals when adding the dimension to the query projection” concerns the alternative task “reevaluate grouping and totals when adding the dimension to the query projection”, but the stated failure is that a query has an aggregation column but the grouping fields create one group per unique transaction. The required measure is to review grouping columns and Sum/Count aggregation placement.
The proposed “Apply a correct filter in the query or at the query execution boundary” tests a different control: apply a correct filter in the query or at the query execution boundary. The reported condition is that a query has an aggregation column but the grouping fields create one group per unique transaction; the more direct action is to review grouping columns and Sum/Count aggregation placement.