|
Options
|
Description
|
|
Display
Style
|
Specifies the type of search filter displayed.
|
Dropdown
list
|
The Dropdown List display style option
displays a list of values retrieved from the database. The list contains
all values used in the designated database field.
|
|
List
box
|
The
List box display style option displays a list of values retrieved from the
database. The list contains all
values used in the designated database field.
|
|
Text
box
|
The Text Box display style option
displays a text entry box.
Application uses can enter any text, and the associated database
table and field will be searched for matching entries.
|
|
|
List
box rows
|
Specifies
the screen height, in rows, when the ‘Allow multiple selection’ option is
enabled for the List box filter.
|
|
Text
box columns
|
Screen width, in characters, of the text box used to enter the
search string.
|
|
Populate
filter with all possible values
|
Build the filter list (list of possible values) from a lookup
table, typically referenced via a foreign key or virtual foreign key
relationship.
This
option is typically faster because the associated lookup table usually has a
small number of values.
|
|
Populate
filter with only values contained in the result set
|
Build the filter list (list of possible values) from actual
data in the filtered table. Only
values in the table will be in the resulting filter list.
This
option is typically slower because scanning the filterd table requires a full
table scan of the entire table to determine the data values contained in the
table.
Note: The two dropdown filter options may still
behave differently even if the table column being filtered is not a foreign
key:
-
The "all possible values"
option will always subject all values in the table to the filter.
-
The "result set values"
option subjects only a subset of the values in the table to the
filtering, e.g., when the result set has already been filtered by
another filter on the page.
|
