-
Open the Query Management tab.
-
Click the Create Query button.
Note: Query now also supports Date, Time and Date_Time data types.
-
From the Table Name drop-down list select the table you want to create the query for. This field is required.
-
In the Name of Query field, enter a unique name for the query you
want to create. This field is required. The maximum number of characters allowed is 50.
Note: The Name of Query cannot be named as "No Custom" or "Custom Filter". It is
not allowed.
-
In the Comments field, enter a description or comments relating to
the query. This text is optional and will not be displayed in Spectrum Spatial Analyst .
-
From the Select Column drop-down list select the column of the table you want to set a query condition for.
-
From the Select Operator drop-down list select the comparison operator required.
-
From the Select Parameter drop-down list select the appropriate parameter type to be used in the query.
-
Enter the label or value for the parameter under Value/Label for Parameter.
-
Click the
button to add the query condition to the list. Repeat steps 6 - 9 to add more query conditions if required. A maximum of 10 can be added.
Note: If you want to delete a query condition click the
button next to it in the list.
-
Click the Save button to create the query.
The new query is inserted in alphabetical order in the Saved Queries
list. You can then edit, delete, or clone it.