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()
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()
No comments:
Post a Comment