SQL Customization
SQL customization
You can customize configuration parameter values with SQL strings to specify the exact settings suiting your business configuration requirements. You apply customized SQL commands in the Configuration Manager under the Parameter Management settings.
To apply a customized SQL, enter your custom code in the SQL field for the appropriate parameter. The field is only available if custom SQL is enabled for the selected parameter.
Supply your SQL command in the SQL Statement field and click Save. The SQL supplied overwrites all other value settings for the parameter setting.
You might have to supply a parameter value for the parameter setting as well, before you can save the settings. The sql statement takes precedence over any other values set for the parameter setting.