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

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

Advanced Query Append Selected Features

Appends selected features in the map query results table

Advanced Query Change Display Color

Advanced Query Change Display Color

Changes the colors in which the results are displayed in ArcMap

Tools on the Production Advanced Query window

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.

NotaNota:

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:

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:

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.


9/30/2010