SQL Queries - Common SQL Queries - Queries on Metrics - How to get ids of metrics given part of the name of the metric

Purpose of Query

This query provides the metric ids for metrics given part of a metrics name. This can be run on a local or central database.

Applicable CAST Version

Applicable RDBMS

Query for CSS

You can substitute other phrases or words below in the metric description search. Please remember to use lower case in the description search.

SELECT METRIC_ID,
       METRIC_DESCRIPTION
FROM   DSS_METRIC_DESCRIPTIONS
WHERE  language              = 'ENGLISH'
AND    lower(METRIC_DESCRIPTION) LIKE '%avoid using%';

Query result example

580;“Avoid using Structures”
588;“Avoid using Global Variables”

Query result interpretation

The output is the metric ID followed by the metric description.

Notes/comments

Related Pages