MxLoader

 View Only

Related Content

  • 1.  REST API

    Posted 10-04-2021 09:07
    Edited by Manuel Guyot 10 days ago

    Hi,

    I would like to know if it is possible to have such Query with API:

    (reportdate < trunc(current date) and status not like 'KLAR' ) or (reportdate >= trunc(current date))

    I know that the "or" is not possible, so is there a way to go around to get that kind of Query?

    Thanks.

    ------------------------------
    MG
    ------------------------------



  • 2.  RE: REST API

    Posted 10-10-2021 14:02
    I have collected a quick guide on REST queries in this post.
    Unfortunately OSLC standard does not support OR and NOT operators. Only AND operator works. MxLoader complies with the standard.

    The IBM documentation provides more details about REST APIs. The 'opmodeor' parameter will treat all ANDs as ORs. Awful solution so I will never add to MxLoader.
    Another option would be to support 'saved queries'. This means you can store your query in Maximo and use it in MxLoader. It may be an option...

    Really sad OSLC APIs offer so limited features to filter data.

    ------------------------------
    Bruno Portaluri
    ------------------------------

    Original Message


  • 3.  RE: REST API

    Posted 10-11-2021 10:00
    Edited by Manuel Guyot 10 days ago

    Thanks for your answer Bruno, I was afraid that it would be as you say, for that Query, using only one OR, I made two different Queries that I run after each other and then I join the result in a new Excel, it will be more difficult if I have several OR in the Query.

    Thanks for the documentation and thanks again for all your work, this is opening new doors in our Maintenance work, getting KPIs from Maximo and be able to visualize to have a goal to be better!

    ------------------------------
    MG
    ------------------------------

    Original Message