group by clause in fetch method

Dynamics 365 for Finance and Operations/AX Developer Forum
1

i have 2 tables custpackingslipjour and custpackingsliptrans . using these 2 table want to write a query that fetches data to be group by itemid .

i dont have column itemid in custpackingsliptrans table. i want to sum up quantity by grouping itemid

state itemid qty

AP AP01 10 qty , state is in custpackingslipjour && itemid is in custpackingsliptrans

AP AP02 20

AP AP01 20

I need output like

AP AP01 30

AP AP02 20

how do i write the query in fetch

thanks in advance

2

dateRange =

this.query().dataSourceTable(tablenum(CustPackingSlipJour)).findRange(fieldnum(CustPackingSlipJour,DeliveryDate)).value();

by writing above i am getting this

state itemid qty

AP AP01 10

AP AP02 20

AP AP01 20

I need

state itemid qty

AP AP01 30

AP AP02 20

thanks

3

Your code merely reads a value of a range; it obviously don’t sum nor group anything.

Use these methods:

QueryBuildDataSource.addGroupByField(fieldNum(…))

QueryBuildDataSource.addSelectionField((fieldNum(…), SelectionField::Sum)