|
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.
|
