Даю код
PHP код:
qbds = newQuery.addDataSource(tableNum(InventJournalTable));
qbdsInvJourTrans = newQuery.dataSourceTable(tableNum(InventJournalTrans));
qbdsInvJourTrans = qbds.addDataSource(tableNum(InventJournalTrans));
qbdsInvJourTrans.addLink(fieldNum(InventJournalTrans, JournalId),
fieldNum(InventJournalTable, JournalId)
);
qbdsInvJourTrans.joinMode(JoinMode::InnerJoin);
qbdsInvJourTrans.orderMode(OrderMode::GroupBy);
qbdsInvJourTrans.addSelectionField(fieldNum(InventJournalTrans, Qty), SelectionField::Sum);
qbdsInvJourTrans.addSortField(fieldNum(InventJournalTrans, ItemId));
qbdsInvJourTrans.addSortField(fieldNum(InventJournalTrans, TransDate));
qbdsInvJourTrans.addRange (fieldNum(InventJournalTrans, ItemId)).value(queryValue(InventJournalTrans_1.ItemId));
qbdsInvJourTrans.addRange (fieldNum(InventJournalTrans, TransDate)).value(queryValue(InventJournalTrans_1.TransDate));
qv = this.query().dataSourceNo(1).findRange(fieldNum(InventJournalTable, JournalId)).value();
qbds.addRange(fieldNum(InventJournalTable, JournalId)).value(
queryValue(qv));