SQL Queries - CAST Central Base - Queries on Objects - How to get the list of objects in exclusion
Purpose of Query
This page provide the details regarding the list of Objects and corresponding metric selected for exclusion in dashboard.
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, Oracle, SQL Server
SELECT DOS.object_full_name , DOE.metric_id
FROM DSS_OBJECT_EXCEPTIONS DOE
join DSS_OBJECTS DOS
on DOS.object_id = DOE.object_id
Query result example
object_full_name ; metric_id
java.wk.inter.getID;7908
Query result interpretation
The query returns the object selected for exclusion and ID of the Quality Rule for which it was Excluded
Notes/comments
Related Pages