Filter

Property

Description

Database field

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

<TABLE>.<FIELD>

Applies To

List Box

Field to filter

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

<TABLE>.<FIELD>

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:

CONTAINS

Contains

NOT_CONTAINS

Does not contain

STARTS_WITH

Starts with

NOT_STARTS_WITH

Does not start with

ENDS_WITH

Ends with

NOT_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