|
|
#1 |
|
Участник
|
Цель, создать вот такой вот Query
Код: while select ledgerJournalTrans
where ledgerJournalTrans.TransDate == todayDate
&& ledgerJournalTrans.AccountType == LedgerJournalACType::Cust
exists join ledgerJournalTransLink
where (ledgerJournalTransLink.Voucher == ledgerJournalTrans.Voucher
&& ledgerJournalTransLink.TransDate == ledgerJournalTrans.TransDate
)&&
(ledgerJournalTransLink.AccountType == LedgerJournalACType::Bank ||
(ledgerJournalTransLink.AccountType == LedgerJournalACType::Cust
&& ledgerJournalTransLink.OffsetAccountType == LedgerJournalACType::Bank))
{...}Код: value = strfmt('((%1 == "%2") || ((%3 == "%4") && (%5 == "%6")))',
fieldId2name(TableNum(LedgerJournalTrans), fieldNum(LedgerJournalTrans, AccountType)),
queryValue(LedgerJournalACType::Bank),
fieldId2name(TableNum(LedgerJournalTrans), fieldNum(LedgerJournalTrans, AccountType)),
queryValue(LedgerJournalACType::Cust),
fieldId2name(TableNum(LedgerJournalTrans), fieldNum(LedgerJournalTrans, OffsetAccountType)),
queryValue(LedgerJournalACType::Bank));
linkedQbds.addRange(fieldNum(LedgerJournalTrans, DataAreaId)).value(value);Код: ... ((B.ACCOUNTTYPE=193) OR ((B.ACCOUNTTYPE=202) AND (B.OFFSETACCOUNTTYPE=193)))) ...
|
|
|