You use the Query by Attributes window to create a SQL statement to search for GIS features and application records using attributes and values. When you perform a query, the system creates a map extent displaying all of the found GIS features highlighted on the map. The system also displays the GIS records in the Current Results section in the left pane of the Map tab.
Results are categorized as Linked or Non-linked. If you query GIS features, the system lists results that are linked to records in the current application under the heading "Linked Results." The system lists GIS features that do not have matching record in the current application under the heading "Non-linked Results." Similarly, if you query application records, the system sorts the results into Linked and Non-linked, depending on whether the current application record has a matching GIS feature.
Note: To perform searches based on the attributes of application records in the Query by Attributes window, your system administrator must have joined the GIS and Maximo tables.
In the Tasks section in the left pane of the Map tab, click Query by Attributes. The Query by Attributes window opens.
In the Resource field, select the map document to query from the drop-down list.
In the Layer field, select the feature class that you want to search from the drop-down list.
In the Attribute field, select the attribute, or database column, of the feature class that you want to query.
In the Operator field, select the SQL operators for the search.
In the Value field, enter the value to search for.
To add the selected values to the Select field, click Add. If all of the values you selected are valid for the search, the system displays the search string in the Select field.
Optionally, you can click And or Or and select another set of values within the same layer. Click Add to add additional search strings to the query.
Click Run to perform the query; click Clear to clear the query. The system displays matching features, highlighted, on the map, and displays the result set under Current Results in the table of contents.
In the Query by Attributes window, click Load. The View/Manage Queries window opens.
Search for the query you want and click OK to return the values of the query to the Query Builder window. If the Resource and Layer of the selected query is not valid for the current map document, the system displays a notification message.
To add the selected values to the Select field, click Add. If all of the values you selected are valid for the search, the system displays the search string in the Select field.
Optionally, you can click And or Or and select another set of values in the Query Builder fields within the same layer. Click Add to add additional search strings to the query.
Click Run to perform the query; click Clear to clear the query. The system displays matching features or records, highlighted, on the map, and displays the result set under Current Results in the Task pane.