The Production Advanced Query Command
The Production Advanced Query Command allows you to query features across an entire database using a Structured Query Language (SQL) expression, then presents the results in a tabular format. The table displays the results of the query based on the fields selected in the Select Features Using a Query dialog box.
The following tools are available on the Production Advanced Query window:
Button |
Name |
Function |
---|---|---|
|
Advanced Query SQL |
Creates a SQL expression to query features across a database as well as determine the fields that are displayed in the query table results |
|
Advanced Query Append Selected Features |
Appends selected features in the map query results table |
|
Advanced Query Change Display Color |
Changes the colors in which the results are displayed in ArcMap |
The query results return values based on the SQL expression created in the Select Features Using a Query dialog box. Query results can also be edited in an edit session. However, if the query returns records from multiple layers, any invalid fields for a layer will be unavailable.
All query results returned by the Production Advanced Query Command are cleared when the Production Advanced Query window is closed.
About SQL expressions
A SQL expression can be defined to query features across a database. The results of the query are displayed in the table created with the Production Advanced Query Command.
SQL expressions are built according to a standard syntax, which includes the following:
- Strings must always be enclosed within single quotes. For example:
COUNTRY = 'United States'
- Expressions are evaluated according to standard operator precedence rules. For example, the part of an expression enclosed in parentheses is evaluated before the part that is not enclosed.
- Wildcards can be used for data in file and enterprise geodatabases.
Learn more about building a SQL expression
With the query builder for the Production Advanced Query Command, you can also control what is displayed in the results table aside from your expression results. You can choose to display any of the following with the results:
- Additional fields for the layers being used in your expression
- All available fields
- Field name aliases
Interacting with query results
On the Production Advanced Query window, you can interact with both the table records and the features with which they are associated. You can select and zoom to features as well as reverse any color changes that have been made using the Advanced Query Change Display Color tool.
You can also work with records in the table by inverting the current selection set, deleting rows, deleting all table records, and refreshing the table. Inverting the table selection selects all the rows in the table that are not currently selected.