SQL Queries - CAST Management Base - How to deactivate rules in the assessment model

Purpose of Query

This page provides a query that allows you to deactivate rules in the assessment model

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server❓
Microsoft SQL Server❓
CSS2✅
CSS3✅

Query for CSS

  1. Run the following query on the management database, providing the list of the quality rules you wish to inactivate:
UPDATE cms_am_qual_rules
SET    active        =0
WHERE  metric_id IN (<list_of_your_qrs>);

Query result example

Indication of the number of rows updated by the above query

For example the following are the list of the current quality rules associated with GreenIT:

20140522
20140523
20140524
20140525
20140526

  1. Once the query has been run, open CAST-MS and put a check in the assessment model so that the quality rule is deactivated.

  2. Once done. you can proceed with a snapshot without these quality rules.

Query for Oracle

Enter the SQL query

Query result example

Query result interpretation

Notes/comments

Related Pages