SQL Data Unique Values rule

Rule description

This rule queries the specified SQL data source and returns all unique values in the specified SQL column.

Use this rule when you need to get a report with unique values in the specified SQL column.

Setting name	Description
SQL instance	Specify the name of the SQL Instance as defined in the Utils Extension SQL Server configuration. Using the Default SQL Instance setting will retrieve the current setting from the SQL Connection settings of the Utils extension. Note: For more information, please see Connecting to Microsoft SQL Server data source article.
SQL database name	Specify database name from selected SQL Instance.
SQL table	Specify SQL Table or View from the selected database. Click the [...] button to display a list of tables from which to choose.
SQL credentials	Specify the database from the data source SQL Instance. Click the [...] button to enter SQL Credentials. Note: Windows Authentication cannot be used to access a Microsoft SQL Server database. The account must be a Mixed Mode or SQL Account.
Data Source Filter	You can use the point-and-click filter builder for the specified data source. Note: If Where Clause is also specified, it will be applied and DataSource Filter will be ignored.
Unique values for this column	Specify the column to read the values from. Note: If the column does not contain a string or anything that can be converted to a string (the like INT), then the error will be displayed: "Values in the selected column <Column name> cannot be converted to a string."
More options
Limit SQL query results	Specify the number of records to limit query results.
SQL timeout	Specify SQL Server connection timeout. By default, it is 30 seconds.

Version	Notes
8.4.0	The rule has been introduced in the product.