Purpose of Query
This page provide you the list of the objects violation list for a given quality rule per application module and snapshot.
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
CSS |
Query for CSS
SELECT ds.snapshot_name , app.object_full_name AS application_full_name, module.object_full_name AS module_full_name , art.object_name AS artifact_name , art.object_full_name AS artifact_full_name , typ.typnam AS artifact_type FROM dss_objects art INNER JOIN dss_object_info snap_art ON snap_art.object_id = art.object_id INNER JOIN dss_link_info l2 ON l2.next_object_id = art.object_id AND l2.link_type_id = 3 AND l2.snapshot_id = snap_art.snapshot_id INNER JOIN dss_link_info l1 ON l1.next_object_id = l2.previous_object_id AND l1.link_type_id = 1 AND l1.snapshot_id = l2.snapshot_id INNER JOIN dss_link_info l0 ON l0.next_object_id = l1.previous_object_id AND l0.link_type_id = 1 AND l0.snapshot_id = l1.snapshot_id INNER JOIN dss_objects module ON module.object_id = l1.previous_object_id AND module.object_type_id = 20000 /* functional module */ INNER JOIN dss_object_info snap_module ON snap_module.object_id = module.object_id AND snap_module.snapshot_id = snap_art.snapshot_id INNER JOIN dss_objects app ON app.object_id = l0.previous_object_id AND app.object_type_id = -102 /* application */ INNER JOIN dss_object_info snap_app ON snap_app.object_id = app.object_id AND snap_app.snapshot_id = snap_art.snapshot_id INNER JOIN typ ON typ.idtyp=art.object_type_id JOIN dss_snapshots ds ON ds.snapshot_id = snap_app.snapshot_id JOIN dss_metric_results dmr ON dmr.snapshot_id = snap_app.snapshot_id AND dmr.object_id = art.object_id AND dmr.metric_value_index = 1 AND dmr.metric_id = <metric_id> +1 --- WHERE ds.snapshot_id = ---Activate this line if you want to restrict the query to only one snpashot ORDER BY ds.snapshot_name , app.object_full_name , module.object_full_name, art.object_name
Query result example
"Computed on 201612191550";"application_new";"capta_new full content";"Arcs";"[C:\CASTMS\Deploy\capta_new\cpp\src\Common\Arc_classes.h].[Arcs]";"C_CLASS"
Query result interpretation
The query returns the objects violation list for the quality rule of metric_id = 66024 per application module and snapshot.
Notes/comments
Related Pages