Select Action Properties

The following properties can be provided for the Select action in the Properties window, General tab:

  • Name: Any logical name for the Select action.
  • No Value: This specifies where an empty value appears (in the list). The following options are available:
    • Default: The empty value appears as the first value in the list.
    • Option: The empty value appears at the bottom of the list.
    • No: The empty value does not appear in the list.
  • Showoninput: Specify the columns to display in a multi column drop down list. Enter single or comma separated values. For example, if shownoninput=1,3 then columns 1 and 3 will be displayed in the drop down in the record UI.
  • Show Header: By default, there is no header in the data ( header="no"). Select this checkbox to display as the column header.
  • Select Type: Type can be Enum or Table. Each type has a different set of properties displayed in the Property window.

    Enum Type: The following properties are displayed for the Enum Type:

  • Column: The number of columns is solely determined by the col attribute.
  • Use First Row As Header: If you have select Show Header checkbox, then select this check-box if you want the first row of data to be displayed as the column header.
  • Attributes: Add constant values or declared variables to the table using the Add button on the right of the table. Select const or variable or context variable from the Type drop-down list and enter the value corresponding to the type in the Literal field. Use the delete button to delete values from the table.

    Table Type: The following properties are displayed for the Table Type:

    • Source Type: Defines the source to retrieve data from. Can be either Datasource or SQL.
    • Linktype Variable Source: Lists repositories and datasources based on the selected source type.
    • Type: Type can be either Literal or Constant.
    • Distinct: Select this checkbox to filter duplicates and display only distinct or unique values from retrieved values. For example, if a column for "city" has a city repeated twice, the result set will display the city only once.
    • Attributes: Displays attributes associated with the defined source type variable.
    • Order By: Allows sorting the result set based on columns specified. Multiple columns can be specified (comma separated).

      The value for order must be specified in the following format. order="[-]<columnpostion1>[,[-]<columnposition2>,..]"

      where: 
- indicates descending order
<columnpositon> specifies column position based on selected columns.

    • Where: Type in an SQL where clause syntax.