Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Note

This step is alternative to Existing Data Source.

...

  1. Click Click to Add Column to add the columns manually to the designer area.
    Image Removed
    Image Added

  2. Provide the column details and add them to the designer area based on the description provided in the following table:

    1. Basic Config:
      Image Removed

      Image Added

      #

      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

      Datatype

      Indicates the kind of data item by the values it can take or the operations that can be performed on it.

      String

      4Parent Column ID

      This Parent Column ID indicates the Name of the column, which must appear as grouping header of the current column.

      For example:
      Consider the following configuration:

      Column IDData TypeParent Column
      TRANS_DATE_RANGE

      date


      FROM_DATE

      date

      TRANS_DATE_RANGE

      TO_DATE

      date

      TRANS_DATE_RANGE

      The above configuration displays the columns in the app to appear as shown in the following table:

      Transaction Data Range

      From DateTo Date

      12-08-2013

      18-08-2013

      07-09-2014

      09-09-2014


      -
      5Entitlement CriteriaMap 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 

      6Display as TitleToggle on: Displays the data of the column as title. This option must be selected for only one column.
      Toggle off: Does not display the data of the column as title.
      Toggle off
      7Business Key PositionThis key position identifies the uniqueness of a row based on columns that exist, in accordance with the business rules.
      8Drill Down IndicatorIndicates 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
      89ChannelIndicates whether the Column is applicable for all devices or Desktop or Mobile or Tablet.
      Select the applicable channel for the column.Desktop
      All


    2. Position:
      Image Removed
      Image Added


      #

      Field Name

      Description

      Sample Value

      Position 

      1

      Mandatory Column

      Toggle on: Indicates that the current column always appears in the view. Item Column 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.

      Toggle off

      2

      Item VisibilityColumn 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.

      Note

      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 Column Visibility value will automatically change to Yes and will be unavailable for the user.


      Toggle on

      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 in Column Visibility.
      Toggle on: Displays the column in the view.

      Toggle off: Hides the column from the view.


      Example 1: For a column, if Item Column 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 Column 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.

      Toggle off

      4PriorityPrioritizes the selection of channels. 1 indicates All Channels, 2 indicates Desktop and Tablet and 3 denotes Mobile. Based on the Priority, the chart will get displayed in the functional application, involving the type of channel, which was chosen by the user.