Table Search Configuration

Select database fields that participate in the full-text search function.

Option

Description

Operator

Specifies the type of filtering operation to apply to the field.

Note:  These filter operators are usually only used with String / Text-type database fields:

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

Case sensitive

Indicates whether to perform a case-sensitive text search.

See Also

Configuring Table and Record Panels

Panel Options Selection

Panel Fields Selection

Table Search Configuration

Table Filtering Configuration

Table Column Total Configuration