MxLoader

 View Only

  • 1.  Is there a solution to use OR in the query?

    Posted 06-14-2022 00:18
    My client asked to translate the following to use in the MXLoader.

    (targstartdate = '2022-05-05' or schedstart => '2022-05-05') and status in ('COMP,','CLOSE')

    They are using REST as the source and API as the authentication,  So, part of the statement translates to

    status in ["COMP","CLOSE"]

    but, there seems to be no solution to the OR, the closest I've found is

    or(schedstart="2022-05-05", targstartdate="2022-05-05")

    though that doesn't work for the MXLoader.

    Does someone have a solution?

    ------------------------------
    Regards,
    Craig Kokay
    ISW
    Maximo Practice Manager
    eMail: ckokay@isw.net.au
    Phone: +61-411-682-040

    #IBMChampion2022
    ------------------------------


  • 2.  RE: Is there a solution to use OR in the query?

    Posted 06-14-2022 18:05
    Aside from a saved query, there's not a way to do an "and" and an "or" inside of the same REST API request until MAS 8.7/Manage 8.3. This will also be added to Maximo 7.6.1.3 when that is released in the 3Q 2022. If you're using MAS and need to know how to do it let me know and I can figure out how to utilize the feature (I haven't had a chance to use it yet myself).

    ------------------------------
    Steven Shull
    IBM
    ------------------------------

    Original Message


Related Content