ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

Creating a definition query for a Reviewer table

Available with Data Reviewer license.

A definition query can be used to limit which records are visible in the Reviewer table. The definition query is actually a Structured Query Language (SQL) query that is applied to the Reviewer table records. The records that match the parameters specified in the query are the only ones visible in the table. As a default, the definition query for a Reviewer table is set to match the session number.

The query can be defined using any field in the Reviewer table and all the unique values. For example, if you want to find all the errors that have been manually committed to the error table, you could set up a query such as "ORIGINCHECK = 'Reviewer Commit Error Tool'". Custom fields can also be used in the query so the table can be more focused for your needs.

Once you create the query, it can be validated, saved, and loaded. The validation process validates the query you created and informs you of the number of records that are found using the query. You can also save the query and load it as needed.

  1. Start ArcMap.
  2. Start a Reviewer session in one of the following:
    • A file, personal, or SQL Server Express geodatabase
    • An enterprise geodatabase
    • An existing Reviewer workspace
  3. Click the Reviewer Table button Reviewer Table on the Data Reviewer toolbar.
  4. Click the Reviewer Table Properties button Reviewer Table Properties on the Reviewer Table window.

    The Reviewer Table Properties dialog box appears.

    Properties tab

  5. Click the Reviewer Table Definition Query tab.

    Reviewer Table Definition Query tab

  6. Click SQL Builder.

    The Select Features Using a Query dialog box appears.

    Select Features Using a Query

  7. Double-click a field name to use with the query in the Fields list.

    The unique values are automatically populated in the Values field.

  8. Click Add.

    The field name is added to the Where Clause text box.

  9. Click an operator.

    You have a choice of standard operators, including equal, not equal, less than, and greater than, as well as operators such as Like, Or, and And.

  10. Double-click the value to use with the query in the Values field.

    Tip:

    You can view how many records are going to be returned by the query by clicking Verify.

  11. Click OK.

    The Reviewer Table Definition Query tab appears with the new query.

  12. Click OK.

The Reviewer table now only shows the records that were filtered by the query.

Related topics

  • Fields in the Reviewer table

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal