Hello Maximo Experts,
I have a requirement to fetch latest 10 WOs for an assetnum input from a mobile search page. As the number of such WOs can be large, I created an automation script based query and made that available thru the object structure.
Environment:
-
Platform: Maximo Application Suite (MAS) 9.0
-
App: Native Maximo Mobile (e.g., Work Order Tracking / Technician)
-
Query Method: Object Structure Automation Script (Query type)
-
Parameterization: Using saved-query-param / sqp: prefix
The Problem: I have implemented an Automation Script-based query on a clone of standard Object Structure (e.g., MXAPIWODETAIL). The script is designed to accept dynamic parameters using the sqp: syntax.
When testing via the Role-Based App (Web version) or direct REST API calls, the query works perfectly. The script executes, consumes the parameters, and returns the filtered data set.
However, when I attempt to use this same query within the Technician Maximo Mobile app, it fails to return data or ignores the parameters entirely. It seems the Offline Sync Engine in the mobile shell handles these requests differently than the standard web-based OSLC provider.
What I’ve Verified:
-
The Automation Script is registered correctly in the Query Definition of the Object Structure.
-
The query is marked as Public.
-
The browser-based Role-Based app (which uses the same OSLC resources) works as expected.
The Question: Is there a specific configuration required in the app.xml (MAF) to force the native mobile sync engine to pass sqp: parameters to the server? Does the native Maximo Mobile framework support saved-query-param for script-based queries, or is this restricted to standard SQL-based saved queries?
Any guidance on the XML syntax or required maximo-datasource settings for MAS 9.0 would be greatly appreciated.
Current <maximo-datasource> definition given below:
<maximo-datasource cache-expiry-ms="1" id="woAssetHistoryDS" object-structure="HALMOBWODETAIL" saved-query="OSQUERY.HALMOBWODETAIL.HALLATEST10WO" saved-query-params="{{'assetnum': ''}}" page-size="10" pre-load="false" notify-when-parent-loads="false" selection-mode="single" order-by="targcompdate desc">
<schema id="a1_hiswo">
<attribute id="a1_hiswo1" name="wonum"/>
<attribute id="a1_hiswo2" name="description"/>
<attribute id="a1_hiswo3" name="assetnum"/>
<attribute id="a1_hiswo4" name="targcompdate"/>
<attribute id="a1_hiswo5" name="wopriority"/>
<attribute id="a1_hiswo6" name="worktype"/>
<attribute id="a1_hiswo7" name="siteid"/>
<attribute id="a1_hiswo8" name="location"/>
<attribute id="a1_hiswo9" name="statusdate"/>
<attribute id="a1_hiswo10" name="status"/>
<attribute id="a1_hiswo11" name="status_description"/>
</schema>
<maximo-datasource-override id="halwoAssetHistoryDS" saved-query="OSQUERY.HALMOBWODETAIL.HALLATEST5WOS" saved-query-params="{{'assetnum': ''}}" selection-mode="single" page-size="5"/>
<maximo-datasource-override id="halwoLocationHistoryDS" saved-query="OSQUERY.HALMOBWODETAIL.HALLATEST5WOS" saved-query-params="{{'location': ''}}" selection-mode="single" page-size="5"/>
</maximo-datasource>