Запрос ничего не возвращает, хочу одному журналу сопоставить только одну строку из строк :
Query legerJournalTableQuery = new Query();
QueryBuildDataSource legerJournalTableDS,legerJournalTransDS;
;
legerJournalTableDS = legerJournalTableQuery.addDataSource(tablenum(LedgerJournalTable));
legerJournalTableDS.addRange(fieldnum(LedgerJournalTable,posted)).value(queryvalue(NoYes::Yes));
legerJournalTableDS.addRange(fieldnum(LedgerJournalTable,journalName));
//legerJournalTableDS.addRange(fieldnum(LedgerJournalTable,offsetAccount));
legerJournalTableDS.addRange(fieldId2Ext(fieldnum(LedgerJournalTable,Dimension),4));
legerJournalTableDS.addRange(fieldnum(LedgerJournalTable,offsetAccountType)).value(queryvalue(LedgerJournalACType::Bank));
/*legerJournalTableDS.orderMode(orderMode::OrderBy);
legerJournalTableDS.addSortField(fieldNum(LedgerJournalTable,PostedDate));
legerJournalTableDS.addSortField(fieldNum(LedgerJournalTable,OffsetAccount), SortOrder:
escending);
*/
legerJournalTransDS = legerJournalTableDS.addDataSource(tablenum(LedgerJournalTrans));
legerJournalTransDS.relations(true);
legerJournalTransDS.addSelectionField(fieldNum(LedgerJournalTrans,AmountCurCredit),SelectionField::Sum);
legerJournalTransDS.addSelectionField(fieldNum(LedgerJournalTrans,AmountCurDebit),SelectionField::Sum);
legerJournalTransDS.addSortField(fieldnum(LedgerJournalTrans,journalNum));
legerJournalTransDS.orderMode(OrderMode::GroupBy);
legerJournalTransDS.addRange(fieldnum(LedgerJournalTrans,TransDate));