SQL Passthrough Data Set Selector List Properties

The name of the data table column returned by the SQL Passthrough DataSet that contains the display text for the list items.

This setting is optional. If no column name is specified, the first column in the data table is used.

If a ItemDisplayTextColumnName is specified and multiple queries are defined by the SQLPassthroughDataSet, then the same column name is used for each query.

See also: SQLPassthroughDataSetID, ItemValueColumnName

The name of the data table column returned by the SQL Passthrough DataSet that contains the value for the list items.

This setting is optional. If no column name is specified, the first column in the data table is used.

If a ItemDisplayTextColumnName is specified and multiple queries are defined by the SQLPassthroughDataSet, then the same column name is used for each query.

See also: SQLPassthroughDataSetID, ItemDisplayTextColumnName

The ID of the SQLPassthroughDataSet metadata instance that defines the query or queries used to generate the list items. If multiple queries are defined by the SQLPassthroughDataSet, each query is executed and the combined results are used as the list items. Each value returned by a query should be a valid member name.

See also: ItemDisplayTextColumnName, ItemDisplayTextColumnName

DefaultPolicy.None

Indicates how the default selection is determined.

None - No item(s) is selected by default.

LastUsedItem - The last item(s) used within the context is the default. The context is specified by the view’s SelectorLastUsedItemContext setting.

FirstItem - The first item in the list is the default.

AllItems - All items in the list are automatically selected. This option only applies when multiple selections are allowed.

SpecifiedString - The DefaultSelectionString value, which can be tokenized, is the default.

Today - Today’s date. This option only applies to Date selectors and Generic selectors that use the SelectorComboBox SelectorControlObjectTypeID.

The semi-colon delimited list of values that represents the default selection when the DefaultSelectionPolicy is SpecifiedString. The string can be tokenized.

The DefaultSelectionString is only applicable when the DefaultSelectionPolicy is set to SpecifiedString.

See also: DefaultSelectionPolicy

The string that represents the item value(s) used as the default when the DefaultSelectionPolicy is LastUsedItem and no last used item exists. The value can be tokenized.

false

Determines whether the default selection is validated.

Typically, the best runtime performance is achieved by setting the ValidateDefaultSelection to false and the DefaultSelectionPolicy to LastUsedItem.

A semi-colon delimited list of ID’s of the other selectors that affect this selector list. At runtime, when a selection changes for any of the specified selectors, this selector list is automatically re-generated.

The text displayed by the selector when no item(s) is selected. The setting is often used to display a prompt. The value can be tokenized.

The text assigned to the token when no item(s) is selected. The value can be tokenized.

NullSelectionTokenValue is typically used to specify the token value for a selector that is configured as optional, but still needs to be represented by a token.

;

When the user is allowed to select multiple items, the token value is a delimited list of substrings in which each substring represents a selected item. The TokenValueDelimiter defines the character(s) used to delimit the substrings within the token value. By default, the delimiter is a semi-colon.

See also: TokenValueFormat, TokenValueItemFormat

The format used to create the value that is assigned to the token.

By default, the token value is a semi-colon delimited list of substrings in which each substring represents a selected item. If the token value needs to contain additional text prepended and/or appended to the text representing the selected item(s), you can use the TokenValueFormat to specify the text.

The format must contain the format item {0}, which is replaced with the selected item(s) string.

See also: TokenValueDelimiter, TokenValueItemFormat

false

Controls whether a single quotation mark within the token item value is automatically escaped with another single quote.

For example, if TokenValueItemEscapeSingleQuote is True and the selected item is Ville De’anjou, the item value assigned to the token is Ville De''anjou. This setting is intended for use when the token is used within a relational query.

When the user is allowed to select multiple items, the token value is a delimited list of substrings in which each substring represents a selected item. If each substring needs to be prepended and/or appended with additional text, you can use the TokenValueItemFormat to specify the text.

The format must contain the format item {0}, which is replaced with the selected item string.

For example, to enclose each item string in single quotes, the TokenValueItemFormat can be set to '{0}'

See also: TokenValueDelimiter, TokenValueFormat