General X++ Development

How do I add a range to a form datasource query?

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

How do I add a range to a form datasource query?

SSunny Vasty75 reputation · answered Aug 13, 2026

Use the datasource's QueryBuildDataSource.

X++
QueryBuildDataSource qbds = MyTable_ds.queryBuildDataSource();
QueryBuildRange range;

range = qbds.addRange(fieldNum(MyTable, Status));
range.value(queryValue(MyStatus::Open));

MyTable_ds.executeQuery();

Nothing fancy here: add the range, set the value, then rerun the datasource query.