External List Selector
Used to select a value from an external list.
Properties
| Property | Description |
| AutoCompleteMode | Defines how the selectors behave. There are two possible values: Start / Contains. |
| Enabled | Boolean indicating whether or not the component is enabled. |
| Filter | Filters the returned values (a list of filters can be defined). Filters must use the syntax [field name] [operator] [value]. The possible operators are: = , <> , >= , <=, contains , not contains, startingwith, not startingwith. See below for an example. |
| FormatDisplayValue | Macro string defining a display format for the text in the selector's text zone. Only the fields used to define display formats will be used to filter the elements in the selector list. |
| FormatSelectValue | Macro string defining a display format for an element in the selector list. These fields are not used to filter the elements in the selector list. |
| FormatResultValue | Macro string defining a format for the value returned by the selector. |
| Hint | Specifies the user hint string that will appear in the component's interactive help bubble. |
| ListName | External list name. |
| SelectorColumns | List of fields to display as columns in the selector table that opens when the user clicks on a selector's button. |
| TabIndex | Integer indicating the component's tab order (Qubes 5.6). |
| ValueInitial | Determines the component's initial value when the screen opens and each time it is reset (see Reset Button). |
| Visible | Boolean indicating whether or not the component will be visible. |
List of available fields
The available fields are those defined in the definition of the external list object.
Value
The component returns the value defined by the FormatResultValue property, if the selection is valid; if not, it will return an empty string.
Remarks
You absolutely must enter the external list's name for the ListName property.
The filters are only implemented for external data storage lists, not for lists that reference a database external to Qubes.
If a description is enterred for a column, it will be used as the displayed text in the column header instead of the column label.
Examples
To filter for a list's "code" field (starting with a fixed "rand" string) and its "num" field (cell A2), the "filter" syntax is:
=List('code startingwith rand';'num='+A2)