Friday, December 22, 2017

X++ code read a dynamic query range value in ax 2012 r3

query = new query();

ex :
 query  = Query  object 3300db70: SELECT SUM(AvailPhysical), SUM(PMUOM1Qty), SUM(PMUOM2Qty), SUM(PMNetWeight) FROM InventSum(InventSum_1) GROUP BY InventSum.ItemId, InventDim.inventBatchId, InventDim.configId, InventDim.InventColorId, InventDim.InventStyleId, InventDim.InventSiteId, InventDim.InventSizeId, InventDim.InventLocationId, InventDim.wMSLocationId JOIN * FROM InventDim(InventDim_1) ON InventSum.InventDimId = InventDim.inventDimId AND ((configId = N'C000002')) AND ((InventLocationId = N'WH00002')) AND ((InventSiteId = N'Barcelona'))
TYPE:
 Query


queryRun.query().dataSourceTable(tablenum(InventDim)).rangeField(fieldNum(InventDim, inventLocationid)).value()

Export a copy of the standard user acceptance testing (UAT) database

 Reference link: Export a copy of the standard user acceptance testing (UAT) database - Finance & Operations | Dynamics 365 | Microsoft ...