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