Purpose of Query
The purpose of this page is to provide queries to check if an assessment model data is loaded properly during snapshot.
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Query for CSS
To confirm if the assessment model data is properly loaded you can run the below query. You can try with any specific quality rule as shown below :
select * from cms_am_qual_rules where metric_id=<Quality_rule_id>;
Query result example
If the data is loaded properly then you can see the quality rule result as below :
Otherwise, query will not provide any result.
Query result interpretation
Query will provide result of quality rule data if assessment model is loaded properly. If not, you will not be able to see any result for the above query.
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