Purpose of Query
This query lists Technical Depbt by application and modules
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, CASE dob.object_type_id WHEN -102 THEN 'Application' ELSE 'Module' END, dob.object_name, CASE dmr.metric_id WHEN 68001 THEN 'Technical Debt' WHEN 68901 THEN 'Technical Debt Added' ELSE 'Technical Debt Removed' END, metric_num_value FROM dss_metric_results dmr JOIN dss_objects dob ON dob.object_id = dmr.object_id WHERE dob.object_type_id in (-102, 20000) AND dmr.metric_id in (68000, 68001, 68901, 68902) AND dmr.metric_value_index = 1 ORDER BY 1, 2, 3, 4, 5
Query result example
3;"Application";"My application";"Technical Debt";1000
3;"Application";"My application";"Technical Debt Added";25
3;"Application";"My application";"Technical Debt Removed";20
3;"Module";"___My application union content___";"Technical Debt";1000
3;"Module";"___My application union content___";"Technical Debt Added";25
3;"Module";"___My application union content___";"Technical Debt Removed";20
Query result interpretation
The query returns snapshot id, application/module name and current, added and removed Technical Debt value
Notes/comments
Related Pages