Field Formatter
A new drop-down Field Formatter has been incorporated in SQL Template Designer. The drop down has the following options to select:
Comma Separated Values
Navigate to Formatting tab and select the required field and then click Advance. Advanced dialog box is displayed with Field Formatter drop down.
User can add drill-down to each comma separated values within one column.
To view the drill down report for the SQL output, specify the drill down command in the Drilldown text box
For example: systemName=backupPolicy&policyId=##drillDownPara##