SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of all metrics by technology for all business and technical criteria

Purpose of Query

The purpose of this query on the central base is to get a list of all metrics by technology for all business and technical criteria.

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

SELECT csv_quality_tree.b_criterion_id  ,
       csv_quality_tree.b_criterion_name,
       csv_quality_tree.t_crit          ,
       csv_quality_tree.t_weight        ,
       csv_quality_tree.t_criterion_id  ,
       csv_quality_tree.t_criterion_name,
       csv_quality_tree.m_crit          ,
       csv_quality_tree.m_weight        ,
       csv_quality_tree.metric_id       ,
       csv_quality_tree.metric_name     ,
       dss_object_types.object_type_name
FROM   csv_quality_tree csv_quality_tree            ,
       dss_metric_param_types dss_metric_param_types,
       dss_metric_types dss_metric_types            ,
       dss_object_types dss_object_types
WHERE  csv_quality_tree.metric_id            = dss_metric_types.metric_id
AND    dss_metric_types.metric_id            = dss_metric_param_types.metric_id
AND    dss_metric_param_types.object_type_id = dss_object_types.object_type_id
AND
       (
              (
                     dss_metric_types.metric_options IN (8,1,9,0)
              )
       AND
              (
                     dss_metric_param_types.param_name='Techno filter'
              )
       AND
              (
                     dss_metric_types.metric_group=1
              )
       )

UNION ALL

SELECT csv_quality_tree.b_criterion_id  ,
       csv_quality_tree.b_criterion_name,
       csv_quality_tree.t_crit          ,
       csv_quality_tree.t_weight        ,
       csv_quality_tree.t_criterion_id  ,
       csv_quality_tree.t_criterion_name,
       csv_quality_tree.m_crit          ,
       csv_quality_tree.m_weight        ,
       csv_quality_tree.metric_id       ,
       csv_quality_tree.metric_name     ,
       'All Languages/Technologies'
FROM   csv_quality_tree csv_quality_tree,
       dss_metric_types dss_metric_types
WHERE  csv_quality_tree.metric_id = dss_metric_types.metric_id
AND
       (
              (
                     dss_metric_types.metric_options IN (8,1,9,0)
              )
       AND
              (
                     dss_metric_types.metric_group=1
              )
       )
AND    NOT EXISTS
       (SELECT DISTINCT 1
       FROM             dss_metric_param_types dss_metric_param_types
       WHERE            (
                                         dss_metric_param_types.param_name='Techno filter'
                        )
       AND              dss_metric_types.metric_id = dss_metric_param_types.metric_id
       )

Query result example

60012;"Changeability";0;8;61001;"Architecture - Multi-Layers and Data Access";0;7;610;"Avoid circular references between header files";"C++"

60012;"Changeability";0;8;61001;"Architecture - Multi-Layers and Data Access";0;7;1070;"Avoid header files circular references";"C"

60012;"Changeability";0;8;61001;"Architecture - Multi-Layers and Data Access";0;1;1606;"Triggers should not directly modify tables, a procedure or function should be used instead";"PL/SQL"

60012;"Changeability";0;8;61001;"Architecture - Multi-Layers and Data Access";0;1;1606;"Triggers should not directly modify tables, a procedure or function should be used instead";"Forms"

60012;"Changeability";0;8;61001;"Architecture - Multi-Layers and Data Access";0;8;2236;"Avoid use of standard SQL API";"JEE"

Query result interpretation

The query returns the business criterion id and name, the technical criterion id , weight, and name, and the metric id, weight, name, and applicable technologies.

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