|
![]() |
#1 |
Участник
|
проверочный job. подходит для обеих версий
Код: static void testSysQuery_CountLoops_rnr(Args _args) { Query q = new Query(); QueryRun qr; QueryBuildDataSource qbds; QueryBuildDataSource qbds2; LedgerTable lt; LedgerTrans ltrans; Integer loops; Integer Total; qbds = q.addDataSource(tablenum(LedgerTable)); qbds.addSortField(fieldnum(LedgerTable,AccountPlType)); qbds.orderMode(0); qbds2 = qbds.addDataSource(tablenum(LedgerTrans)); qbds2.joinMode(JoinMode::INNERJOIN); qbds2.addLink(fieldnum(LedgerTable,AccountNum),fieldnum(LedgerTrans,AccountNum)); qbds2.addSortField(fieldnum(LedgerTrans,TransDate)); qbds2.orderMode(0); info(q.dataSourceNo(1).toString()); qr = new QueryRun(q); info(strfmt('Total: %1',SysQuery::countTotal(qr))); info(strfmt('Loops: %1',SysQuery::countLoops(qr))); } |
|