Purpose of Query
This page consists of all the SQL queries which have to be executed on Central Database related to metrics. For instance these queries provide information such as getting the list of critical metrics , deactivated metrics , technical criteria to which a metric belongs to, etc.
Applicable CAST Version
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x |  |
| 8.1.x | |
| 8.0.x | |
| 7.3.x | |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server | |
| CSS2 | |
Details
- Please select the page you are interested in from the below list -
- SQL Queries - CAST Central Base - Queries on Metrics - How to calculate Technical Debt manually
- SQL Queries - CAST Central Base - Queries on Metrics - How to calculate the number of bookmarks per object per metric_id
- SQL Queries - CAST Central Base - Queries on Metrics - How to check if some metrics have Total Checks equal to 0
- SQL Queries - CAST Central Base - Queries on Metrics - How to check which rules have changed criticality between snapshots
- SQL Queries - CAST Central Base - Queries on Metrics - How to detect when the violation has been added into the Action Plan
- SQL Queries - CAST Central Base - Queries on Metrics - How to find out whether a given metric has been calculated in a given snapshot
- SQL Queries - CAST Central Base - Queries on Metrics - How to get a list of complex objects
- SQL Queries - CAST Central Base - Queries on Metrics - How to get the added metric list between two Cast versions
- SQL Queries - CAST Central Base - Queries on Metrics - How to get the cyclomatic complexity by type of objects for a specific snapshot
- SQL Queries - CAST Central Base - Queries on Metrics - How to get the deleted metric list between two Cast versions
- SQL Queries - CAST Central Base - Queries on Metrics - How to get the details of critical violations displayed in the STATISTICS section in the left panel
- SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of all metrics by technology for all business and technical criteria
- SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of all metrics with param name and values
- SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of critical metrics
- SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of customized metrics
- SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of deactivated metrics
- SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of items making up technical and business criteria
- SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of quality rules attached to more than two technical criteria
- SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of sub component metrics of any Parent Metric
- SQL Queries - CAST Central Base - Queries on Metrics - How to get the source code position for objects with violations
- SQL Queries - CAST Central Base - Queries on Metrics - How to get the technical criteria of the metric given the metric Id
- SQL Queries - CAST Central Base - Queries on Metrics - How to get the violation list of objects for a given quality rule per application module and snapshot
- SQL Queries - CAST Central Base - SQL Queries on Metrics - How to check the values of a quality measure for a module
- SQL Queries - CAST Central Base - SQL Queries on Metrics - How to get Cost complexity distribution by application and modules
- SQL Queries - CAST Central Base - SQL Queries on Metrics - How to get Technical Debt by application and module
- SQL Queries - CAST Central Base - SQL Queries on Metrics - How to get the list of metrics using parameters
- SQL Queries - CAST Central Base - SQL Queries on Metrics - Number of violation occurrences by quality rule
- SQL Queries - CAST Central Base - SQL Queries on Metrics - Violations scores
- If you do not find the information you are looking for or solution for your problem, please contact CAST Technical Support
Notes/comments
Related Pages
