Purpose of Query
This query lists violations details: Snapshot id, Module name, Rule Id, Rule Name, Rule Technology, object id, Object Name, Object Fullname, Object Type, Rule Criticality
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
CSS3 | |
CSS2 |
Query for CSS
SELECT dmr.snapshot_id AS "snapshot id", dob.object_name AS "Module Name", dmr.metric_id - 1 AS "metric ID", dmt.metric_name AS "Quality rule name", tech.techno_type_name AS "Quality rule technology", dos.object_id AS "object id", dos.object_name AS "object name", dos.object_full_name "as object full name", t.typdsc AS "object type name", CASE DMTT.metric_critical WHEN 1 THEN 'Critical' WHEN 0 THEN 'Non Critical' END AS "crtical" FROM dss_metric_results dmr JOIN dss_metric_types dmt ON dmt.metric_id = dmr.metric_id JOIN dss_metric_type_trees DMTT ON DMTT.metric_id = DMT.metric_id JOIN dss_objects dos ON dos.object_id = dmr.object_id JOIN typ t ON t.idtyp = dos.object_type_id JOIN dss_metric_types TMT ON TMT.metric_id = dmr.metric_id - 1 JOIN dss_metric_param_types PT ON PT.metric_id = TMT.metric_id AND PT.param_index = 1 JOIN dss_techno_display_vw tech ON tech.techno_type_id = PT.object_type_id JOIN dss_link_info dli ON dli.next_object_id = dmr.object_id AND dli.snapshot_id = dmr.snapshot_id AND dli.link_type_id = 3 JOIN dss_object_info doi ON doi.object_id = dli.previous_object_id AND doi.snapshot_id = dli.snapshot_id JOIN dss_technologies dtl ON dtl.module_type_id = doi.object_type_id JOIN dss_link_info dliMF ON dliMF.next_object_id = dli.previous_object_id AND dliMF.snapshot_id = dli.snapshot_id AND dliMF.link_type_id = 1 JOIN dss_objects dob ON dob.object_id = dliMF.previous_object_id AND dob.object_type_id = 20000 WHERE dtl.techno_type_id = PT.object_type_id
Query result example
1;"Selectif Backup full content";7784;"Avoid Artifacts with lines longer than X characters";"C++";7802;"Connect_server_button_Click";"[C:\CASTMS\Deploy\Selectif Backup\My Package\GUI\conectionProfileCreation.h].[ConnectionInterface].[Form1].[Connect_server_button_Click(System::Object*, System::EventArgs*)]";"C++ Method";"Non Critical"
Query result interpretation
The query returns Snapshot id, Module name, Rule Id, Rule Name, Rule Technology, object id, Object Name, Object Fullname, Object Type, Rule Criticality
Notes/comments
Related Pages