CMS Assessment Model - Information - Configuration or Parameterization of number of columns in Avoid Complex Select

The purpose of the page is to describe how  to change or parametrize 'the number of columns returned by select clause' to be treated as violation in the metric Avoid Complex Select.

Description:

The default behavior of this metric is: “If select clause is returning more than 9 columns, this will be treated as a violation”.

If the business requirement is to change or parametrize 'the number of columns returned by select clause' to be treated as violation, it can be done as described below -

1. Modify "C:\Program Files\CAST\<Version of CAST>\configuration\Metrics\Package\SQL Metric\Select9Columns.xml" and change the <THRESHOLD> value as per requirements:

   <ADD_ACTION>
      <MATCH>PLSQL_SELECTMORE</MATCH>     
       <MATCH>OTHERS_SELECTMORE</MATCH>
       <MATCH>ABAP_OPENSQL_SELECTMORE</MATCH>     
       <THRESHOLD>9</THRESHOLD>
       <TOKEN>TOKEN_AND_TREE_ELEMENT.TOKEN_VALUE</TOKEN>
       <SIGNATURE>TOKEN_AND_TREE_ELEMENT.SIGNATURE_VALUE</SIGNATURE>
       <RESULT_COUNT>VALUE</RESULT_COUNT>
   </ADD_ACTION>

2. Run Analysis + Snapshot