Columns
- Last UpdatedApr 08, 2024
- 3 minute read
The Columns tab displays the column definitions for the Database View. A column can be based on a database attribute or expression. Attribute columns are editable in the Database View by the user unless the Readonly property is set. Columns based on expressions are not editable by the user when accessed in the data grid. It may be helpful when managing the columns to drag the Data Source field onto the grouping section in order to quickly view what columns are defined from the different Data Sources.
The drop-down list at the top of the Columns tab control contains all the Data Sources defined in the grid. The functionality of the toolbar which contains the New, Add Standard Attributes and Add Status Column options are affected by which Data Source is selected from drop-down list.
|
New |
Creates a column definition for the selected Data Source and selects it in the grid. |
|
Delete |
Deletes the selected column(s). |
|
Add Standard Attributes |
Adds all of the common attributes for the elements of the selected data source. Add Standard Attributes is enabled if columns don't already exist for all of the common attributes and the element type for the selected Data Source can be identified. |
|
Add Distributed Attributes |
Adds all of the distributed attributes for the elements of the selected data source. Add Distributed Attributes is enabled if columns don't already exist for all of the distributed attributes and the element type for the selected Data Source can be identified. |
|
Add Status Column |
Adds a column to display the status for the selected Data Source. The Qualifier must then be set for the column to the status definition to present to the user. |
The fields in the grid are enabled/disabled depending on whether the column is based on an attribute or an expression.
|
Data Source |
The element the attribute or expression is obtained from. |
|
Attribute/Expression |
The database attribute or expression used to get the value of the column. PML 2 is not supported. |
|
Column Name |
The default display name for the column, if unset then the display name is derived from the attribute or the expression used to get the column value. If duplicate names are input then the first column has the requested name, subsequent columns have an index added (for example: 'Name (2)') |
|
Description |
The data type of the column, this is known for the columns based on attributes but must be set for columns based on expressions. If set to the wrong type, errors display when the data is accessed. |
|
Type |
The data type of the column, this is known for the columns based on attributes but must be set for the columns based on expressions. If set to the wrong type, errors display when the data is accessed. |
|
Read Only |
If set the user is not able to modify the values in the column. |
|
Expression Syntax |
The syntax of the expression if the column is expression based (PML or XPATH). |
|
Qualifier |
A qualifier used for attributes that require qualification such as STVVAL. |
Note:
If a column is a case variant (as defined by the new flag on User Defined Attributes
UDAs), specify a specific (case sensitive) Case name in the qualifier column of the
Database View Editor for that column. As a result the column in that view becomes specific for just that
case.