|
qu = new query();
qbds = qu.addDataSource(tableNum(LedgerJournalTrans));
qbds.AddRange(fieldnum(LedgerJournalTrans, TransDate)).value('>' + queryvalue(headerTransDate));
qbds = qbds.addDataSource(tableNum(LedgerJournalTable));
qbds.joinMode(joinMode::ExistsJoin);
qbds.addLink(fieldnum(LedgerJournalTrans, JournalNum), fieldnum(LedgerJournalTable, JournalNum));
qbds.AddRange(fieldnum(LedgerJournalTable, Posted)).value(queryvalue(NoYes::Yes));
|