In the Maximo 7.6.1.3, there are some enhancements which have been delivered by IBM in the Integration Module. One of the new features is the addition of a checkbox - Load Query From All Apps on Object Structure.
If we check this checkbox, all the queries - which are Public or Private created by users in a given Maximo application related with Object Structure become available without adding them into Query Definition of Object Structure.
For example - I have the same Object Structure - E3MASSET as shown in the screenshot above. This object structure has no query added in Query Definition and also checkbox - Load Query from All Apps is not checked.
Below API provides the queries which are available to be used as savedQuery with Maximo APIs.
http://<server:port>/maximo/api/apimeta/mxapiasset?lean=1
If we access this API from Postman, the output will be shown below which provides the queries which are available to be used in the savedQuery clause with API.
Though there are some queries which are available in the Asset application created by users earlier as shown below.
Now select the Load Query From All Apps checkbox and query the output of the same API.
As we can see all other SQL queries which are available on Asset application are also available now which can be used as savedQuery in Maximo NextGenRest APIs to get the output.
This functionality is very useful for 3rd party integration where query created by users are readily available for consumption without any extra steps required for Configuration at Object Structure level.
Author:
Prashant Sharma
Delivery Head - IBM Maximo & EAM360 Mobile App
