Property |
Description |
||||||||||||||||||||||
Database field |
Specifies the database field to which the filter applies in the format: <TABLE>.<FIELD>
|
||||||||||||||||||||||
Field to filter |
Specifies the database field to which the filter applies in the format: <TABLE>.<FIELD>
|
||||||||||||||||||||||
Index field |
Specifies the database field from which the list is populated |
||||||||||||||||||||||
Filter operator |
Specifies the filtering operation to apply. Date / Numeric operators
See Setting the default time string for date range filters. String / Text operators: These filter operators are usually only used with String / Text-type database fields:
Using them with numeric or date fields may not be supported in some cases depending on the field's validation type, display format and storage formats. These operators allow filtering by “fragments” of field values, and these fragments often cannot be parsed or interpreted correctly for fields that use certain types of format strings. For example, using the Contains operator on a date field searching for '12' should work correctly. However, searching for '12/30' may not work correctly, because the '/' isn't actually stored in the database field. |
||||||||||||||||||||||
Maximum generated items |
The maximum number of database query values automatically populated in the control. This keeps a filter list from becoming excessively large. If the number of values exceeds the maximum displayed values, only the maximum number are displayed. Please note that this setting only works for filter dropdowns; it does not for data selection dropdowns.
|