|
QueryRun LedgerTransQueryRun;
QueryRun VendTransQueryRun;
Query LedgerTransQuery;
Query VendTransQuery;
QueryBuildDataSource LedgerTransQBDS;
QueryBuildDataSource VendTransQBDS;
LedgerTrans ledgerTrans;
VendTrans vendTrans;
;
VendTransQuery = new Query();
VendTransQBDS = VendTransQuery.addDataSource(TableNum(VendTrans));
VendTransQBDS.addRange(FieldNum(VendTrans,AccountNum)).value('Ivanov');
VendTransQueryRun = new QueryRun(VendTransQuery);
LedgerTransQuery = new Query();
LedgerTransQBDS = LedgerTransQuery.addDataSource(TableNum(LedgerTrans));
ledgerTransQBDS.addRange(fieldnum(LedgerTrans,Crediting)).value(SysQuery::value(NoYes::No));
LedgerTransQueryRun = new QueryRun(LedgerTransQuery);
while (LedgerTransQueryRun.next())
{
ledgerTrans = LedgerTransQueryRun.get(TableNum(LedgerTrans));
info(ledgerTrans.AccountNum);
//
}
И вобщем нужно отфильтровать LedgerTransQuery согласно отфильтрованному VendTransQuery. Как можно такое реализовать?
|