Copy of SQL Param Map ID - Grouped Grid Multi level

The following steps are applicable, only if SQL Param Map ID is used to connect to datasource:

1. Click Click to Add Column to add the columns manually to the designer area.
   
   
   
   
2. Provide the column details and add them to the designer area based on the description provided in the following table:
   
   
   1. Basic Config:
      
      
      

      
      

      #	Field Name	Description	Sample Value
      Basic Configuration
      1	Column ID	Unique ID of the column as in the database.
      2	Column Display Name Key	Localized label key of the column that appears as column title on the grid.
      3	Entitlement Criteria	Map the entitlement criteria defined in the database to the field/column based on which the data must be filtered and displayed in the app for the user. For more information, please refer the Data Level Entitlements Configuration.	LOAN_CRI
      4	Drill Down Indicator	Indicates the hyperlink in the column values that lead to another process or window. The developer must use CWEC.DRILL_DOWN handler to write the hyperlink click action logic. See section Adding Handlers to the App for more information.	No
      5	Data Type	Indicates the Canvas data type of the column.	string
      6	Channel	Indicates whether the Column is applicable for all devices or Desktop or Mobile or Tablet. Select the applicable channel for the column.	Desktop

   2. Group Configuration:
      
      
      
      

      
      

      #	Field Name	Description	Sample Value
      Group Configuration
      1	Is Groupable	Marks the columns which the end-user can group. Toggle On: Enables the grouping options. A Group By combo box will appear just below the header with the columns which has Is Groupable toggle On. Toggle Off: Does not enable the grouping options. The Groupable columns combo will not appear.	Yes
      2	Is Grouped	This option is available when 'Is Groupable' is 'Yes'. Toggle On: Marks the columns by which the records can be grouped. Toggle Off: Does not mark the columns for grouping.	Yes
      3	Mandatory Group Indicator	This option is available when 'Is Groupable' toggle in On. Toggle On: Marks the column as mandatory in the group so that the user cannot remove it from aggregation. Toggle Off: Marks the column as non-mandatory in the group and the user can remove it from aggregation.
      4	Position In Group	This option is available when 'Is Grouped' or 'Mandatory Group Indicator' toggle is On. Assigns the position of the column in the grouped grid. Lowest value puts the column in top-level group.
      5	Rel.Pos In Group	This option is available when 'Is Grouped' or 'Mandatory Group Indicator' toggle is On. Order of the Groupable columns selection for aggregation.
      6	Constraining Field	This option is available when 'Is Grouped' or 'Mandatory Group Indicator' is toggle is On. Select any other column that is already defined as mandatory to restrict the aggregation on the current column.
      7	Aggregate using	Provides the aggregate of the grouped data based on the option selected. At least any one column should have the aggregate values to group records.	Count

   3. Column Template:
      
      
      

      
      

      #	Field Name	Description	Sample Value
      Column Template
      1	Enable Column Template	Toggle on: Switch on the toggle to select a custom template for the column. Select the template from the list that pops up once you switch on the toggle. Toggle off: Switch off the toggle if you do not want to select custom template for the column.

      
      
      

   4. Position:
      
      
      
      

      
      

      #	Field Name	Description	Sample Value
      Position
      1	Mandatory Column	Toggle on: Indicates that the current column always appears in the view. Item Visibility cannot be set if Column Mandatory Indicator toggle is on. Toggle off: Indicates that the current column may or may not appear on the view.
      2	Item Visibility	Enables the column to show or hide. The end-user can make a column visible or invisible. Toggle on: Displays the column in the view. Toggle off: Hides the column from the view. This option will be available for the user only when the Column Mandatory Indicator is set to No. If the Column Mandatory Indicator is set to Yes, then the Item Visibility value will automatically change to Yes and will be unavailable for the user.
      3	Hide Column	Enables the column to show or hide. The end-user can make a column visible or invisible. This property over rides the property set in Item Visibility. Toggle on: Displays the column in the view. Toggle off: Hides the column from the view. Example 1: For a column, if Item Visibility is set as No and Hidden Indicator is set as No, then in output if Show Hidden Items is selected then the column will be displayed in the grid. Example 2: For a column, if Item Visibility is set as No and Hidden Indicator is set as Yes, then in output if Show Hidden Items is selected the column will not be displayed in the grid.

   5. Sort and Filter:
      
      
      

      
      

      #	Field Name	Description	Sample Value
      Sort & Filter
      1	Sortable Column	Toggle on: Enables the sorting indicator for the column. Toggle off: Hides the Sorting Indicator. The user cannot sort records by the current column.
      2	Column Sort Position	This option is available when 'Column Sortable Indicator' toggle is On. Places the selected column in the defined position for ORDER BY clause in sorting.
      3	Sortable Column ID	Specify the column ID (in data source) by which the data needs to be sorted.
      4	Enable Filter	Toggle on: Enables filtering records by current column. Toggle off: Does not allow filtering of records by the current column.
      5	Is Filtered	Toggle on: Indicates that the current column is filtered. Toggle off: Indicates that the current column is not filtered.
      6	Filter Column ID	Specify the column ID (in data source) by which the data can be filtered. Specify the filter argument and value in the Compare As and Compare Value fields respectively.
      7	Compare As	This option is available when 'Is Filtered' toggle is On. Compares the filtering data with criteria.
      8	Compare Value	This option is available when 'Is Filtered' toggle is On. Compares the value with the filtering data.
      9	Lookup Filter Extra Params	This value is used to call the single lookup app with different entitlement.

      To add dynamic filters to your data, refer Pass Dynamic Value for View Column Filter.