Hi Dynamic users,
I’m using the Query Framwork in AX2013 R3. I have the following query that already works properly.
Query query;
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange qbr1;
QueryRun queryRun;
FromDateTime datelastsync;
datelastsync = DateTimeUtil::addDays(DateTimeUtil::getSystemDateTime(), -1);
query = new Query();
query.allowCrossCompany(true);
query.addCompanyRange(“demo”);
queryBuildDataSource = query.addDataSource(tableNum(CustTable),“CustTable”);
queryBuildDataSource = queryBuildDataSource.addDataSource(tableNum(DirPartyTable),“DirPartyTable”);
queryBuildDataSource.relations(true);
queryBuildDataSource = queryBuildDataSource.addDataSource(tableNum(DirPartyLocation),“DirPartyLocation”);
queryBuildDataSource.relations(true);
queryBuildDataSource = queryBuildDataSource.addDataSource(tableNum(LogisticsLocation),“LogisticsLocation”);
queryBuildDataSource.relations(true);
queryBuildDataSource=queryBuildDataSource.addDataSource(tableNum(LogisticsPostalAddress),“LogisticsPostalAddress”);
queryBuildDataSource.joinMode(JoinMode::OuterJoin);
queryBuildDataSource.relations(true);
The question is: How should I build the Range or filters in the Query() for the following result in SQL:
" … WHERE … AND (CustTable.ModifiedDateTime>@datelastsync OR
DirPartyTable.ModifiedDateTime>@datelastsync OR LogisticsLocation. ModifiedDateTime>@datelastsync OR LogisticsPostalAddress.ModifiedDateTime>@datelastsync ) … "
I have tried in many ways, with .AddRange () and by adding the values (’(% 1% 2>% 3) || … But not return the expected results.
Thank you for your help.