Belajar Komputer & Gadget

static void DateRangeTest(Args _args) { DateRangeTest drt; Query query=new Query(); QueryRun qrun; QueryBuildDataSource qbds; QueryBuildRange qbr; date d=today(); qbds=query.addDataSource(tableNum(DateRangeTest)); qbr=qbds.addRange(fieldNum(DateRangeTest,dataAreaId)); //Method 1 //qbr.value(strfmt(‘(%1<=%2)&& (%3>=%4)’,fieldstr(DateRangeTest,FromDate),Date2StrXpp(d),fieldstr(DateRangeTest,ToDate),Date2StrXpp(d))); //Method 2 qbr.value(strfmt(‘(FromDate<=%1)&& (ToDate>=%2)’,Date2StrXpp(d),Date2StrXpp(d))); qrun=new QueryRun(query); info(qrun.query().dataSourceNo(1).toString()); while(qrun.next()) { drt=qrun.get(tableNum(DateRangeTest)); info(drt.Name); } info(drt.getSQLStatement()); } source

SELECT * FROM SalesTable(SalesTable_1) JOIN * FROM SalesLine(SalesLine_1) ON SalesTable.SalesId = SalesLine.SalesId JOIN * FROM CustTable(CustTable_1) ON SalesTable.CustAccount = CustTable.AccountNum Query query = new Query(); QueryBuildDataSource salesTableDS; QueryBuildDataSource salesLineDS; QueryBuildDataSource custTableDS; salesTableDS = query.addDataSource(tableNum(SalesTable)); salesLineDS = salesTableDS.addDataSource(tableNum(SalesLine)); salesLineDS.relations(true); salesLineDS.fetchMode(QueryFetchMode::One2One); custTableDS = salesTableDS.addDataSource(tableNum(CustTable)); custTableDS.relations(false); custTableDS.addLink(fieldNum(SalesTable, CustAccount), fieldNum(CustTable, AccountNum)); custTableDS.fetchMode(QueryFetchMode::One2One); info(salesTableDS.toString());

Axapta query on multiple tables Hey friends try this code to add multiple tables in query. QueryRun selectReportQuery() {     Query                   query           = new Query();     QueryRun                localQueryRun;     QueryBuildDataSource    qbds1;     QueryBuildDataSource    qbds2;     QueryBuildDataSource    qbds3;     ;     qbds1 = query.addDataSource(tableNum(salesTable));     qbds1.addRange(fieldNum(salesTable, affVendorAdjust)).value('1');     qbds2 = qbds1.addDataSource(tableNum(custInvoiceJour));     qbds2.fetchMode(JoinMode::InnerJoin);     qbds2....