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
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(question)
Microsoft SQL Server(question)
CSS(tick)
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