кому интересно, это вот так делается
X++:
CustVendGroupTable _custVendTable;
QueryBuildDataSource qbr1;
;
_custVendTable = CustVendTable_ds.cursor();
super();
CustVendTable_ds.query().dataSourceNo(1).clearDynalinks();
qbr1 = CustVendTable_ds.query().dataSourceNo(1);
qbr1.orderMode(OrderMode::GroupBy);
qbr1.addSortField(fieldNum(CustVendGroupTable,CustVendGroupId));
qbr1.addSortField(fieldNum(CustVendGroupTable,name));
_queryBuildRange = this.query().dataSourceNo(1).addRange(fieldnum(CustVendGroupTable, CustVendType));
_queryBuildRange.value(QueryValue(element.setFilter(_custVendTable.CustVendType)));
_queryBuildRange = this.query().dataSourceNo(1).addRange(fieldnum(CustVendGroupTable, isGroup));
_queryBuildRange.value(QueryValue(boolean::false));