Available with Data Reviewer license.
The Query Attributes check finds features based on a query against its attribute values.
The purpose of the Query Attributes check is to identify errors based on a Structured Query Language (SQL) query that can include one or more attribute values. Depending on the database type, this query can also include functions (string and numeric) to implement complex queries. Features or rows returned by the query are written as a Reviewer result.
- In parcel management, features that contain invalid values in their parcel identification numbers, invalid conveyance type, and encumbrance type attributes impact attribute consistency between features and reporting.
- In gas utility management, pipe features that contain invalid values in the material and diameter fields impact asset reporting and modeling.
- In water utility management, network features that contain invalid values based on known construction methods (such as butterfly valves measuring less than 24 inches in diameter) impact asset reporting, modeling, and locator services.
Input Layers/Standalone Tables
The input feature layers or stand-alone tables evaluated by the rule.
Valid inputs for this rule type are feature layers and stand-alone tables. To apply the rule on specific features in a feature layer or stand-alone table, click Filter to construct an SQL query.
Query expression to be applied to a feature layer or stand-alone table.
All features or rows whose parameters match those defined in the SQL query are returned as a Reviewer result.
Title property of the Reviewer result created when a non-compliant feature is found.
This information is used to support data quality requirement traceability, automated reporting, and corrective workflows.
Descriptive text of the Reviewer result created when non-compliant features are found.
This information is used to provide guidance to facilitate corrective workflows.
Severity of the Reviewer result created when non-compliant features are found.
This value indicates the importance of the result relative to other results. Values range from 1 to 5, with 1 being the highest priority and 5 the lowest.
Tag property of the Reviewer rule.
This information is used in rule authoring and management workflows to support traceability and reporting of data quality requirements.
- Care should be taken when authoring rules using database-specific functions that may be different than those used in your production environment. For more information, see SQL reference for elements used in query expressions.
- When authoring a rule for multiple layers or stand-alone tables, only those fields that are common (matching name and data type) across all layers or tables can be used in the Search Goal parameter.