Data Quality Tool

The Data Quality Tool enables administrators to check the quality of their data using preconfigured SQL statements. The Data Quality tool can uncover issues ranging from an incomplete field to incorrect calculations.

To launch the Data Quality tool, the machine being used must have the Lucity Administration Tools installed on it. Launch the C:\Program Files (x86)\Lucity\bin\Lucity.DataQuality.exe program.

data quality

Query Selection Tools

The Query Selection tools, which appear at the top of the program, let users choose which Data Quality query(ies) they wish to run.


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 Queries		Runs all the queries in the selected group. Any queries that produce results will open a tab in the Results grid.
Results Grid		Displays the results of the query(ies) as tabs. Located at the bottom of the screen.