Lookup List field

Use this field to present users with a list of choices retrieved from an ODBC database.

Option Description
ODBC data source Select the desired ODBC data source. Only system data sources can be selected as a data source. If no data ODBC source was previously created, a new ODBC data source can be created by selecting the <New…> option.
ODBC data sources administrator Click this button to open the ODBC Data Sources Administrator standard dialog box provided by your OS.

Please refer to the documentation of ODBC Data Sources Administrator for details.

User ID Enter the user name for accessing the ODBC data source. Entering a value for this field is optional. If no entry is made, then the user account running the workflow server will be used.
Password Enter the password that corresponds to the User ID.
Retrieve data from In this group, specify from where the data will be loaded and how it will be presented in the lookup list. There are two options available:
  • Table/View
  • Query
Table/View Select this option, to retrieve data from the table/view. Select the name of the table/view from the drop-down menu.

When you select this option, you should specify a value in the Value column text box.

Value column In this text box, select the name of the column from which values will be loaded into the lookup list.

It is mandatory to fill out this text box for the Table/View option.

Display column In this text box, select the name of the column the values from which will be used in the lookup list as display values.

It is optional to fill out this text box; if nothing is entered, the values listed from the Value column will be displayed.

Query Select this option if you want to provide an SQL query to produce the results which will populate the lookup list.

For more information on SQL scripting syntax, see General SQL syntax.

Maximum number of rows to preload Specify the maximum number of rows to preload into the display when the lookup list is first displayed.
Test data retrieval Click this button to test the connection and lookup settings.
Display mode Select the desired display mode from the drop-down list. There are three modes available:
  • Drop-down list
  • Control list
  • Modal dialog
Allow Multiple Selection If selected, the user will be able to make multiple selections based on the results populated within the lookup list.
Allow user to add items Select this check box to allow the user to add items into the list.

This option is enabled only for Modal dialog display mode.

Maximum number of search results to display Specify the number of results returned when a search is executed. The default value is 25 and the maximum value is 200.