link по ИЛИ между источниками данных

[SRF]

Цитата:

Сообщение от kia

А как этот запрос построить динамически в АХ?

В AX 2009 можно примерно так :

    Query                   query;
    QueryBuildDataSource    qbdsRPayTrans;
    QueryBuildDataSource    qbdsRPayFundMember;
    ;
    query = new Query();
 
    query.queryType(QueryType::Union);
 
    qbdsRPayTrans = query.addDataSource(tableNum(RPayTrans));
    qbdsRPayTrans.unionType(UnionType::Union);
    qbdsRPayTrans.addRange(fieldNum(RPayTrans, SourceDate)).value(...);
    qbdsRPayFundMember = qbdsRPayTrans.addDataSource(tableNum(RPayFundMember));
    qbdsRPayFundMember.addLink(fieldNum(RPayTrans, PayCtype), fieldNum(RPayFundMember, PayCostType));
    qbdsRPayFundMember.addRange(fieldNum(RPayFundMember, CounterUnit)).value(...);
 
    qbdsRPayTrans = query.addDataSource(tableNum(RPayTrans));
    qbdsRPayTrans.unionType(UnionType::Union);
    qbdsRPayTrans.addRange(fieldNum(RPayTrans, PayPeriod)).value(...);
    qbdsRPayFundMember = qbdsRPayTrans.addDataSource(tableNum(RPayFundMember));
    qbdsRPayFundMember.addLink(fieldNum(RPayTrans, PayCtype), fieldNum(RPayFundMember, PayCostType));
    qbdsRPayFundMember.addRange(fieldNum(RPayFundMember, CounterUnit)).value(...);
    qbdsRPayFundMember.joinMode(JoinMode::NoExistsJoin);