Dynamics AX & D365FO Insights Hub

static void queryMultipleValue(Args _args) {     Query                   query;     QueryRun                queryrun;     QueryBuildDataSource    qbds;     QueryBuildRange         qbr, qbr1;     SalesTable              salesTable;     str                     rangevalue;     ;     query = new Query();     qbds = query.addDataSource(tableNum(SalesTable));     qbds.addSortField(fieldNum(SalesTable, CustAccount), SortOrder::Ascending);     qbr     = qbds.addRange(fieldNum(SalesTable, CustAccount));         qbr.value(strFmt("%1,%2,%3", queryValue("US-4000"), queryValue("US-027"), queryValue("US-028")));       queryrun = ne...

static void queryEnumValue(Args _args) {     Query                   query;     QueryRun                queryrun;     QueryBuildDataSource    qbds;     QueryBuildRange         qbr;     PurchTable              purchTable;     ;         query = new Query();         qbds = query.addDataSource(tableNum(PurchTable));     qbds.addSortField(fieldNum(PurchTable, PurchId), SortOrder::Ascending);     qbr     = qbds.addRange(fieldNum(PurchTable, PurchStatus));         qbr.value(enum2str(PurchStatus::Received));         queryrun = new QueryRun(query);         while(queryrun.next())     {         purchTable = query...

static void QueryDateRange(Args _args) {     Query                   query;     QueryRun                queryrun;     QueryBuildDataSource    qbds;     QueryBuildRange         qbr;     PurchLine               purchLine;     TransDate               fromDate, Todate;     ;         fromDate = mkDate(19,11,2016);     Todate   = mkDate(20,12,2016);         query = new Query();         qbds = query.addDataSource(tableNum(PurchLine));         qbds.addSortField(fieldNum(PurchTable, PurchId), SortOrder::Ascending);         qbr     = qbds.addRange(fieldNum(PurchLine, deliveryDate));     ...