Purpose of Query
The queries will provide you with the list of Quality rule that has been deleted since a referenced version.
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS |
Query for CSS
SELECT * FROM <referenced_version_central>.dss_metric_types t WHERE t.metric_group = 1 AND metric_id NOT IN ( SELECT metric_id FROM <new_version_central>.dss_metric_types t WHERE t.metric_group = 1 )
Query result example
-- No rows
Query result interpretation
The above query was run between a central schema of CAST AIP 7.3.1 and a central schema of CAST AIP 8.1.0. The query provides you the metric_id, the metric name and the metric description. There are no deleted metrics between CAST AIP 7.3.1 and CAST AIP 8.1.0
Query for Oracle
Enter the SQL query
Query result example
Query result interpretation
Query for SQL server
Enter the SQL query
Query result example
Query result interpretation
Notes/comments
Related Pages