Configuring Maximo Anywhere
Specifying criteria for retrieving lookup data
Download 1.16 Mb. View original pdf
|
- Navigate this page:
- About this task
| Specifying criteria for retrieving lookup data To narrow the scope of the query fora lookup resource, you can add a WHERE clause to the resource in the application definition file. You can also add these WHERE clauses by using the Anywhere Administration application if it is enabled. The criteria in the WHERE clause are resolved dynamically when lookup data is retrieved from the provider application. About this task By default, the query fora lookup resource 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. You specify those criteria by adding a WHERE clause to the lookup resource in the application definition file. The application definition file fora mobile app can include predefined WHERE clauses for lookup and system resources. The criteria that are expressed in a predefined WHERE clause are required by the mobile app to support system operations and must not be modified. However, you can add additional criteria to predefined WHERE clauses by using the and operator to add custom criteria. 18 Configuring Maximo Anywhere Maximo Anywhere supports the OSLC WHERE clause. The criteria in an OSLC WHERE clause have a standard format that comprises an attribute, an operator, and a constant. For example, the following WHERE clause can be added to the additionallocations lookup resource to retrieve locations in SITE A only: The where clause includes the following items: siteid An attribute of the additionallocations lookup resource. = A comparison operator that expresses equality. No spaces are allowed before or after comparison operators. SITE A A constant that expresses the site value criteria for matching location records. The criteria in a WHERE clause are typically based on attributes of the lookup resource to which the WHERE clause applies. However, a WHERE clause can also include criteria that are based on system resource attributes. For example, the following WHERE clause finds the mylaborcraftrate resource for the labor record that is associated with the current user. The labor record for the current user is given as [${mylabor.laborcode}], where laborcode is an attribute of the mylabor system resource. spi:defaultcraft is an attribute of the mylaborcraftrate system resource: You must not create circular references in WHERE clauses that use attributes from other resources. For example, if the WHERE clause for resource A uses an attribute from resource B, the where clause for resource B must not use an attribute from resource A. The application XSD cannot validate the content of the you must test the updated runtime application before you deploy it to a production environment. Download 1.16 Mb. Share with your friends:
|