Simple Example of using tables in Query in axapta Reprts Query q; QueryRun qr; QueryBuildDatasource qbds; QueryBuildRange qbr; InventTable inventtab; ; q = new Query(); qbds = q.addDataSource(tablenum(InventTable)); qbr = qbds.addRange(fieldNum(InventTable,Status)); qbr.value(queryValue(NoYes::No)); qr = new SysQueryRun(q); while(qr.next()) { inventtab = qr.get(tableNum(InventTable)); info(inventtab.Itemid); }
Microsoft Dynamics Ax,AIF,Axapta, Enterprise portal,,Microsoft , United State,U.S., SharePoint , BI Tools, Performance Tuning, SSRS,Business Logic,Ax ERP Errors and solution,Dynamics 365 Errors Solution,Business software .