|
Можно так:
QueryBuildRange qbr_InventBatch;
;
q = this.query();
qBD_InventJournalTrans = q.DataSourceTable(tablenum(InventJournalTrans)
qBD_InventDim = qBD_InventJournalTrans.addDataSource(tablenum(InventDim));
qBD_InventDim.joinMode(JoinMode::InnerJoin);
qBD_InventDim.fetchMode (0);
qBD_InventDim.addLink(fieldnum(InventJournalTrans,InventDimId),fieldnum(InventDim,InventDimId));
qBD_InventBatch = qBD_InventDim.addDataSource(tablenum(InventBatch));
qBD_InventBatch.joinMode(JoinMode::InnerJoin);
qBD_InventBatch.fetchMode (0);
qBD_InventBatch.addLink(fieldnum(InventDim,InventBatchId),fieldnum(InventBatch,InventBatchId));
qbr_InventBatch = qBD_InventBatch.addRange(fieldNum(InventBatch, itemId));
qbr_InventBatch.value(strfmt("(%1) = %2.%3", fieldstr(InventBatch, itemId), qBD_InventJournalTrans.name(), fieldstr(InventJournalTrans, itemId)) );
|