SQL Queries - CAST Central Base - Queries on Metrics - How to get the deleted metric list between two Cast versions

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

Applicable RDBMS

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