Query Management

To access this tab...
Click Query Management
The Query Management tab allows you to create and manage commonly used queries, specifying the parameters to be used at run time in the filter. When you create a new query and save it, it is added to the list in the Saved Queries section. You can then:
Note: You must select Enable Querying in the Functionality Options section of the Settings tab to make these queries available to the Spectrum Spatial Analyst user.
Button Description
Create Query Creates a new query.
Save Saves the query changes, or the details of the new query.
Clone Creates a replica of a query with a new name.
Delete Deletes the currently selected query.
Undo Undoes the changes made since the last save.

Create/View/Edit Query

This section allows you to enter details of a new query and view, or edit an existing one.

Field Description
Table Name The table that the query is for. This field is required.
Note: You can create more than one query for a table.
Name of Query The unique name of the query for the table above, which is made available to the user for selection. This field is required.
Comments A description of the query, or any comments relating to it. This field is optional and is for administrator use only. It is not displayed to the user.
Add Query Conditions  
Select Column The column to be queried from the table selected.
Select Operator The type of comparison operator used in the condition.
Select Parameter The parameter type used in the condition:

User Input: allows the user to enter their own values.

Pick List: allows the user to select a value from a pick list. The values presented in the list are the unique set of values from the column being queried.

Use this value: if no user input is needed. The value to use for the parameter is entered in Value/Label for Parameter. The user is not shown the parameter.

Value/Label for Parameter The label name for the user input or pick list, or the value to use for the parameter that will be displayed when the query is selected.
Note: Multiselect pick list is supported for {equal, not-equal and like} operators. For others, simple pick list is displayed.

Saved Queries

Use the Saved Queries section to select an existing query to view, edit, clone, or delete it.

Field Description
Table Name The table that the query is for.
Query Name The unique name of the query to be made available to the user for the table selected.
Modified on The date on which the last modification to this query was made.