Query range D365 FO

In this blog of Dynamics Community 101 we will learn the Query range

Using OR:

QueryBuildRange qbr =SysQuery::findOrCreateRange(_qbds, fieldNum(HcmPerfJournal, Owner));

qbr.value(strFmt(‘(%1.%2 == %3) || (%1.%4 == %5)’,

_qbds.name(),

fieldStr(HcmPerfJournal, Owner), enum2int(HcmPerfManagerEmployee::Manager),

fieldStr(HcmPerfJournal, Share), enum2int(NoYes::Yes)));

qbr.status(RangeStatus::Hidden);

Using AND:

queryBuildRange = accessRightsListDataSource.addRange(fieldnum(DEL_AccessRightsList, RecId));

queryBuildRange.value(strfmt(‘((%1.%2==%3) && (%1.%4==%5))’,

accessRightsListDataSource.name(),

fieldstr(DEL_AccessRightsList, RecordType),

accessRecordType,

fieldstr(DEL_AccessRightsList, Id),

_securityKeyArray.value(i)));

Date Range:

queryBuildRange .value(SysQueryRangeUtil::dateRange(DateTimeUtil::date(DateTimeUtil::addDays(currentDateTime,relativeDaysFrom)), DateTimeUtil::date(DateTimeUtil::addDays(currentDateTime,relativeDaysTo)));

or

queryBuildRange.value(SysQuery::range(fromDate, toDate));

Adding multiple Query range x++