Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This step is alternative to Existing Data Source.

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.

      ITEM_ID

      2

      Column Display Name Key

      Localized label key of the column that appears as column title on the grid.

      ITEM ID

      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.


      4

      Datatype

      Indicates the Canvas data type of the column.

      String

      5

      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

      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. Position:



      #

      Field Name

      Description

      Sample Value

      Position

      1

      Mandatory Column Indicator

      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

      Hidden Column Indicator

      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.


  • No labels