Lookup List field

A Lookup List field allows users to specify items from a field a database table.

Option Description
ODBC Data Source Select an ODBC data source to connect with a data provider. You can click <New...> to configure a new ODBC data source item. Only system data sources can be selected as a data source.
ODBC Data Sources Administrator Click this button to open the Windows ODBC Data Source Administrator application to add, delete, or configure data sources with user data source names (DSNs).
User ID Enter a user ID that has permissions to the database. This field is optional. If it is left empty the user account running the AutoStore service will be used.
Password Enter the password that corresponds to the User ID.
Connect Click this button to connect to the ODBC Data Source.
Table View Choose this option to select the table or view. Then specify the following:
  • Value Column — Select the name of the column from which values will be loaded into the lookup list. This value is required.
  • Display Column — Select the name of the column which will provide the names which will be displayed in the lookup list. This value is optional. If this value is left blank, values listed in the Value Column will be displayed in the device console.
  • Description Column — Select the name of the column which will provide the description for the names displayed in the lookup list. This value is optional. Values from this column will be displayed in the details section of the user interface. This option is only available for device panels that display in color.
Query Choose this option to enter a SQL query to produce results that populate the list. Entries for <ValueField> and <DisplayField> are required in the SQL query.

For information about SQL scripting syntax see General SQL Syntax.

Maximum number of rows to load The user can select the maximum number of rows to load into the display when the lookup list is first displayed. The default value is 25, and the greatest number of rows that can be specified for this option is 200.