Queries
The queries define the IBM® TRIRIGA® building location data that is displayed in the map. Any query that is supported by the IBM TRIRIGA 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. For metric queries, in order for a record
link to appear in a pin's mouse-over dialog, the triRecordSY field
must be included as one of the report columns. 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.