General X++ Development

How do I add multiple ranges to a query in X++?

Asked by Sunny Vasty· Aug 13, 2026· 1 answers

How do I add multiple ranges to a query in X++?

SSunny Vasty75 reputation · answered Aug 13, 2026

Add each range separately.

X++
qbds.addRange(fieldNum(CustTable, CustGroup))
    .value(queryValue('10'));

qbds.addRange(fieldNum(CustTable, Blocked))
    .value(queryValue(CustVendorBlocked::No));

Separate ranges on different fields are effectively AND conditions.

If you keep changing the query at runtime, make sure you are not accidentally adding the same range over and over.