query = new Query();
query.addDataSource(tablenum(InventTrans), "InventTrans");
...
query.dataSourceTable(tablenum(InventTrans)).addDataSource(tablenum(InventTransPosting), "InventTransPosting");
query.dataSourceTable(tablenum(InventTransPosting)).
addLink(fieldnum(InventTrans, InventTransId), fieldnum(InventTransPosting, InventTransId));
query.dataSourceTable(tablenum(InventTransPosting)).addRange(fieldnum(InventTransPosting, InventTransPostingType)).
value(queryValue(InventTransPostingType::Financial));
query.dataSourceTable(tablenum(InventTransPosting)).addRange(fieldnum(InventTransPosting, ItemId)).
value(queryValue(_itemId));
...
while (qr.next())
{
inventTrans = qr.get(tablenum(InventTrans));
inventTransPosting = qr.getNo(2);
}
|