Query query;QueryBuildDataSource qbds;QueryBuildRange qbr;QueryRun queryrun;date fromDate = systemDateGet();date toDate = (systemDateGet() + 25);query = new Query();qbds = query.addDataSource(tableNum(MyTable));qbds.addGroupByField(fieldNum(MyTable, DateField));qbds.addGroupByField(fieldNum(MyTable, CurrencyNameField));qbds.addSelectionField(fieldNum(MyTable, DateField));qbds.addSelectionField(fieldNum(MyTable, CurrencyNameField));qbds.addSelectionField(fieldNum(MyTable, EURAmountField), SelectionField::Sum);qbds.addSelectionField(fieldNum(MyTable, USDAmountField),…
in addition to parameters specified in data contracts, reports can also use queries. It’s very handy, because users can specify filters and sorting in exactly…
1) Create a AOT Query Object as your requirement. 2) Create a Job and paste the below code to check the Query Object. static void…