Queries

The queries define the IBM® Maximo® Real Estate and Facilities building location data that is displayed in the map. Any query that is supported by the Maximo Real Estate and Facilities report manager can be applied to the map. Both standard queries and metric queries are supported.

The query with the lowest value in the Display Order field is displayed by default. To select another query, you can click the Show Details tab for the map and select a query from the list.

In GIS sections, query data is filtered and grouped by the geographical data that is displayed in the current map view. Queries must include display columns that are labeled Longitude and Latitude. The Latitude and Longitude fields pinpoint the item on the map.

For metric queries, the structure of the query must be tabular. FFor metric queries, include the triRecordSY field as one of the report columns so that the pin’s hover dialog can display a record link. For standard queries, this step is not necessary since the record link appears in the pin's mouse-over dialog by default.

If the results of the query are in more than one map system, the GIS software does the conversion and displays the results in the basemap.

When a query runs and the query filter includes fields triGisLatitudeNU and triGisLongitudeNU, the Esri JavaScript viewer automatically adds filters to the query. The filters restrict results to within the extents of the map. The triGisLatitudeNU and triGisLongitudeNU field names must be used. Otherwise, filters cannot be added.

A map can return a maximum of 1000 records.