FieldFilter tag data filtering options.
|
|
|
FieldFilter tag data filtering options. |
|
Options |
Description |
|
Table, view or query |
Specifies the name of the table to which the filter is applied. |
|
Field |
|
|
Operator |
Specifies the type of filtering operation to apply to the field. Date / Numeric operators Is 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 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. |
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.
To do this, double click on the date filter corresponding to the To date to display the Page Properties dialog. Go to the Attributes tab and set this property:
|
Pass-Through Attribute |
Value |
|
TimeString |
23:59:59 |