Query string parameters
Each query call can take a list of query string parameters to supply sort, filters, options, and spatial parameters to the query service. This table lists the parameters that you can include.
| Parameter | Description |
|---|---|
| SortIdentifier | ID of the sort option that will be used to sort the query results. This refers to a sort option defined for the query in the Mobile configuration. For example, this URL will invoke the MyBuildingInspections query and sort the results by street name.
|
| QuickFilters | List of quick filters to apply to the query. These refer to filters defined for the query in the Mobile configuration. The sample below will apply the UnScheduled filter to the MyBuildingInspections query.
Note: If you're calling the query service from the mobile device, then only the first quick filter will be applied.
|
| Parameters | Used to set the values of any parameters that the query takes, as defined in the Mobile configuration. For example, the OpenBuildingPermitsStreetName query has a StreetName parameter. To specify a parameter, enter the ID and the value, as shown in this example.
|
| SelectBinds | List of properties to select. The binds must be included when a query is called from the mobile app.
|
| MaxRecords | Maximum number of records to return. |
| Extent | Spatial extent for nearby queries. |
| NoSpatial | The NoSpatial parameter can be set to True to exclude spatial information from the query results. |
| LocalOnly | For spatial queries, setting the LocalOnly parameter to True directs the query service to use the X and Y coordinates in the Infor Operations and Regulations database rather than the GIS service.
Note: Queries that filter by extent do not support searching on assets or records linked to assets when using local coordinates. Because of this limitation, the mobile app is not able to filter assets or associated records such as work orders and building applications.
|