Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Values 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 " on pageĀ 385 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" on pageĀ 385 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.