Failure reporting implementation in Maximo Anywhere

By default, the query that downloads failure data retrieves all records or instances of the resource that are available in the provider application. Depending on the requirements of your mobile app users, you might want to filter the result set to match custom criteria.

To narrow the scope of the query for failure data, you can add a WHERE clause to the queryBases element in the application definition file (app.xml). The criteria in the WHERE clause are resolved dynamically when lookup data is retrieved from the provider application.

For example, you can download work orders with failure codes that are assigned to a specific organization. If the organization that is specified for work orders in Maximo® Asset Management contains the word ORG A, then only the work orders for that organization are downloaded. To limit the records that are downloaded, add the following to the end of the queryBases section:

<whereClause clause="spi_wm:orgid='ORG A'"/>

In the application definition file, there are several queryBases sections of code. The queryBases section that you must modify is located within the following code:

<resource providedBy="/oslc/sp/SmarterPhysicalInfrastructure"
			describedBy="http://jazz.net/ns/ism/asset/smarter_physical_infrastructure#FailureList"
			name="failureListResource"  pageSize="1000"  additionalData="true">