The purpose of this query on the central base is to provide a list of items that make up technical and business criteria. Generally, business criteria will be made up of technical criteria, and technical criteria will be made up of metrics.
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
RDBMS | Yes/No |
|---|---|
| Oracle Server |  |
| Microsoft SQL Server | |
| CSS | |
SELECT DMTT.METRIC_PARENT_ID AS PARENT_ID ,
DMD_PAR.METRIC_DESCRIPTION AS PARENT_NAME,
DMTT.METRIC_ID AS CHILD_ID ,
DMD.METRIC_DESCRIPTION AS CHILD_NAME ,
DMTT.AGGREGATE_WEIGHT ,
DMTT.METRIC_CRITICAL AS CRITICAL_CONTRIBUTION
FROM DSS_METRIC_TYPE_TREES DMTT ,
DSS_METRIC_DESCRIPTIONS DMD,
DSS_METRIC_DESCRIPTIONS DMD_PAR
WHERE DMTT.METRIC_ID =DMD.METRIC_ID
AND DMD_PAR.METRIC_ID =DMTT.METRIC_PARENT_ID
AND DMD.DESCRIPTION_TYPE_ID =0
AND DMD.LANGUAGE ='ENGLISH'
AND DMD_PAR.DESCRIPTION_TYPE_ID=0
AND DMD_PAR.LANGUAGE ='ENGLISH'
ORDER BY DMTT.METRIC_PARENT_ID,
DMTT.METRIC_ID
60017;"Total Quality Index";66068;"Efficiency - Expensive Calls in Loops";10;0
60017;"Total Quality Index";66069;"Programming Practices - Unexpected Behavior";20;0
60017;"Total Quality Index";66070;"Architecture - Architecture Models Automated Checks";22;0
61001;"Architecture - Multi-Layers and Data Access";610;"Avoid circular references between header files";7;0
61001;"Architecture - Multi-Layers and Data Access";614;"Avoid direct usage of database tables (C++)";8;1
The query returns the id of the parent, the name of the parent, the ids and names of the children, along with the weight and critical contribution of the children.
In the example results above, the business criterion Total Quality Index (TQI) is made up of several technical criteria such as 'Programming Practices - Unexpected Behavior', while the technical criterion 'Architecture - Multi-Layers and Data Access' is made up of several metrics such as 'Avoid circular references between header files'
Enter the SQL query
Enter the SQL query
