Data Quality Tool

Select a Database

Provides a list of Lucity programs. Select the program that contains the module you would like to run a Data Quality query against.

Query List

Lists all available queries.

Group

Indicates whether the query belongs to a query group. Queries are organized into groups based on how critical potential data errors might be. Groups of queries can be run together.

Count

Indicates how many records the query identified. The Count displays "-1" until the user runs the query.

Test Name

Lists the name of the test.

Module

Indicates the module the query applies to. If the query does not apply to a specific module, the word 'None' appears.

Description tab

Provides more detailed information about the query.

Sometimes, a stored query is not designed to be run by the Data Quality tool (e.g., queries that are designed to delete bad records). In such cases, this field displays the query that a DBA can run against the database.

SQL tab

Displays the SQL statement that is being run for the selected query.

Run Selected Query

Runs the query selected in the Query List. Any queries that produce results will open a tab in the Results grid.

Number of Open Tabs

Provides a count of the tabs that have produced results.

Open Lucity Web

Opens Lucity Web and displays the records that appeared in the selected tab of the Results grid.

Select Group Queries

Enables the user to select a group of queries to run.

Run Group Query

Runs all the queries in the selected group. Any queries that produce results will open a tab in the Results grid.

Fix It

This button appears for queries that require a simple fix. Click this button to resolve issues discovered by the selected query.

Reprocess Selected

This button appears for the Spatial records query. It clears errors on failed records which allows the Spatial Indexer to reprocess them.