Filter Controls

Notes

The Text Box Range control allows users to define a high and/or low range and to use a wildcard when searching in a range.

The Text Area Wildcard control provides wildcard pattern matching. If a string without a wildcard character is entered into the Text Area Wildcard control, the wildcard character is automatically appended to the string.

Columns with an HTML Area Control Type are not supported on the Filter View. The developer must manually hide columns HTML Area Control Types on the Filter View because the Stewardship Tier does not automatically hide them. Developers can change the control type for the column to a Text Area or Text Box in the Filter View. However, filter criteria is applied against the HTML source, not the rendered display. For example, a string that includes the ampersand (&) character produces erroneous results because the ampersand is a special character in HTML used for escape sequences.

A check box is converted into a list of options::

• Both – Does not limit the result set. This is the default option.
• Checked – Limits the result set to only those records for which the check box is checked.
• Unchecked – Limits the result set to only those records for which the check box is unchecked.

The Selection control allows users to limit results to only those records containing an exact match and follows all the rules of the List control. None is added to all Selection controls. This option does not restrict the result set; it is the default option.

Columns with a Label Control Type are excluded from the filter view. The Label control is not valid for the Horizontal View, and inherently, labels do not represent data.

Columns with the Button control type use the Text Box Range control. When filtering based on the data in these columns, the filter criteria are applied to the underlying cell value. In the case of buttons, the underlying cell value is rendered as the button label. When filtering on a column with a Button Control Type, the filter criteria applies to the button label. If the cell value is NULL or a zero length string, the column name is used for the button label. In these cases, the same filter rules for NULL and zero length strings apply.

Columns with the Image control types use the Text Box Range control. When filtering based on the data in these columns, the filter criteria are applied to the underlying cell value. Columns specified with an Image Control Type can implement either static or dynamic images.

Static images are defined at the column level and the cell value can be any arbitrary value. For example, a column totals the number of orders per customer. Instead of displaying the number, an image is displayed. To see the number, the user must hover over the image. Since the value is in the result set, it can be used as part of the filter criteria.

With dynamic images, the underlying cell value contains the relative or absolute path to the image. The filter criteria are applied against the image path string.

Columns with the File control type use the Text Box Range control. When filtering based on the data in these columns, the filter criteria are applied to the underlying cell value. Since the underlying value of a File control is the file path, physical or virtual, filtering a File control produces a filter on the file path string.

In the case of virtual file paths, the filter is only applied to the relative portion of the path because that is the only portion stored in the table.

The Selection control allows users to limit results to only those records containing an exact match and follows all the rules of the List control. None is added to all Selection controls.

This option does not restrict the result set; it is the default option.

Columns with the DateTime control types use the Text Box Range control. When filtering based on the data in these columns, the filter criteria are applied to the underlying cell value.