Database field

Specifies the database field to which the filter applies in the format:


Applies To

List Box

Field to filter

Specifies the database field to which the filter applies in the format:


Applies To

Quick Selector
Dropdown List
Text Box

Index field

Specifies the database field from which the list is populated

Filter operator

Specifies the filtering operation to apply.

Date / Numeric operators


Is equal to


Is not equal to


Is greater than or equal to

Is less than


Is less than or equal to

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:




Does not contain


Starts with


Does not start with


Ends with


Does not end with

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.

Applies To

Dropdown List