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