Values records specify a set of value options for a particular field. For example, it may be useful to specify a list of values for a State field. This list of values may include some or all states and is used in other parts of the system to automate various data entry tasks as well as the process of creating views.

Note that the Display Fields, Where Clause, and Order By fields on this form are applicable only when Value List Type is set to Entity List to populate a multiple selection dialog in a view's Filter. The logic stored in these three fields specifies the information that appears in the Filter's multiple selection dialog when the Filter's operator is set to In List.

Values records may only be created from the Values tab of the Fields form.

Value (Required)

The text of the value. If you set Value List Type to SQL Statement, enter the SQL statement that defines the records and fields to display in this field . For Entity List types, enter the name of the related entity in the Value field.

Value Culture String ID

If you want to localize the name of the value on a user-by-user basis (based on a user's assigned Culture), specify a Culture Strings record in this field. See Working with Culture Strings for details.

Description

A description of the value.

Description Culture String ID

If you want to localize the value's description on a user-by-user basis (based on a user's assigned Culture), specify a Culture Strings record in this field. See Working with Culture Strings for details.

Display Fields

Used along with the Where Clause and Order By fields to create a SQL statement to populate the contents of a multiple selection dialog, when Value List Type is set to Entity List. The Display Fields field holds a comma-delimited list of the field names to be displayed. The syntax follows the standards of text for the SELECT portion of a standard SQL statement.

Where Clause

Used along with the Display Fields and Order By fields to create a SQL statement to populate the contents of a multiple selection dialog, when Value List Type is set to Entity List. This field contains any additional logic, following the syntax of the WHERE portion of a standard SQL statement.

Order By

Used along with the Display Fields and Where Clause fields to create a SQL statement to populate the contents of a multiple selection dialog, when Value List Type is set to Entity List. This field details the order where the data retrieved is displayed. It follows the syntax of the ORDER BY portion in a standard SQL statement.

Browser not supported