FieldFilter Binding Properties

Go to:

Tools, Properties..., Bindings tab

FieldFilter tag data filtering options.

Options	Description
Table, view or query	Specifies the name of the table to which the filter is applied.
Field	Specifies the field to which the filter applies.
Operator	Specifies the type of filtering operation to apply to the field. 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 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.
Ignore time	If selected, a less precise comparison match is performed on Date fields.
Table control to filter	Indicates the table control to which the filter applies. There may be multiple tables on a page, and at least one table must be selected.

Setting the default time string for date range filters

When using a date range filter on a show table page, the default time string used for the filter is 00:00:00 indicating 12 AM. This works well if you are comparing with the “Is greater than or equal to” operator since you want to display all records greater than equal to the date entered by the end user.

For the “Is less than or equal to” operator, you can specify a default time string of 23:59:59 (11:59:59 PM). This allows the end user to enter a value for the To Date filter and retrieve all records that occur on or before the entered date.

Step 1: Select Tools, Properties... to open the Properties dialog.

Step 2: Select the date filter control corresponding to the To date.

Step 3: Go to the Attributes tab and set this property:

Tab	Pass-Through Attribute	Value
Attributes	TimeString	23:59:59

FieldFilter Binding Properties

Setting the default time string for date range filters

See Also