Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Wednesday, February 11, 2015

Multiple query values on same field in X++(Dynamic query)

Hi,

static void AlfasithMultipleQueryValue(Args _args)
{
    HcmWorker                         HcmWorker;
    QueryRun                             queryrun;
    QueryBuildDataSource        qbdsHCWorker;
    QueryBuildRange                qbr1, qbr2;
    Query                                   query;
    ;

    query = new query();
    qbdsHCWorker = query.addDataSource(tableNum(HcmWorker));
    qbr1= qbdsHCWorker.addRange(fieldNum(HcmWorker,PersonnelNumber));
    qbr1.value("0012547");

    qbr2= qbdsHCWorker.addRange(fieldNum(HcmWorker,PersonnelNumber));
    qbr2.value("002211457");

    queryrun    = new queryrun(query);
    while(queryrun.next())
    {
        HcmWorker   = queryrun.get(tablenum(HcmWorker));
        info(strfmt('%1 – %2',HcmWorker.name(),HcmWorker.email()));
    }
}

Regards,


No comments:

Post a Comment

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...