MxLoader

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
------------------------------

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
------------------------------

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:
Sent: 10-10-2021 14:02
From: Bruno Portaluri
Subject: REST API

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
------------------------------