Skip to main content

Posts

Showing posts with the label querybuilddatasource in code

Simple Example of using tables in Query in MSD axapta Reprts

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);     }