Note |
---|
This step is alternative to step Existing Data Source. |
...
- Click Click to Add Column to add the columns manually to the designer area.
- Provide the column details and add them to the designer area based on the description provided in the following table:
- 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, refer the Data Level Entitlements Configuration.4 Data Type
Indicates the Canvas data type of the column.
string
5 Business Key Position This key position identifies the uniqueness of a row based on columns that exist, in accordance with the business rules. 6 Channel
Indicates whether the Column is applicable for all devices or Desktop or Mobile or Tablet.
Select the applicable channel for the column.DesktopAll
Position:
#
Field Name
Description
Sample Value
Position
1 Column 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 Visibility value will automatically change to Yes and will be unavailable for the user.
2 Priority Prioritizes 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. 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 Enable Filter
Toggle on: Enables filtering records by current column.
Toggle off: Does not allow filtering of records by the current column.- Chart Configurations:
#
Field Name
Description
Sample Value
Chart Configuration
1 Chart Axis
- X Axis: The current column values will be displayed in X axis in the chart.
- Y Axis: The current column values will be displayed in Y axis in the chart.
- None:
- Data Series: The current column values will be displayed as data series in the chart.
Y Series
- Basic Config:
- Click Temporary Preview icon to view the temporary preview of the chart with the columns placed at respective axes.