AX / Dynamics 365 For Finance and Operations blog

I want to add a list of values in an “OR” Condition for a same field in a QueryBuildRange.

The result must be something like that

select * from CustGroup where custGroup.CustGroup == ’50’ || custGroup.Group ==’90’;

To do that Just add range and assign value on the same field multiple times as shown in code below:

Query                   q;
QueryBuildDataSource    qbds;
QueryRun                qr;
QueryBuildRange         qbr;

q = new Query();
qbds = q.addDataSource(tableNum(CustGroup));
qbr = qbds.addRange(fieldNum(CustGroup,CustGroup));
qbr.value(queryValue('50'));

qbr = qbds.addRange(fieldNum(CustGroup,CustGroup));
qbr.value(queryValue('90'));

info(qbds.toString());