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.
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
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 )
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"
Enter the SQL query
Enter the SQL query