Reduce filter

The reduce filter allows a user to limit the row set in the list by using a filter.

Understanding the reduce filter

On mobile devices, when using a DISPLAY ARRAY with a TABLE or SCROLLGRID container, and if the front-end supports filter search facility, the user can enter a criterion in that search field, to show only the rows matching the content of the filter.

Figure: Androidâ„¢ list view with filter field

Android list view with filter field

Reduce filter usage details

The filter search is case-insensitive.

The value entered in the filter field is compared to all fields of visible columns, except columns of the type TEXT or BYTE. The comparison is based on the formatted value. For example, a MONEY column will display values formatted with the currency symbol. To match values in that column, the user must enter exactly the same value (for example, with the currency symbol and the correct decimal separator). When using COMBOBOX fields, the find searches in the visible values of combobox items.

Only text widgets displaying values are searched. Columns using widgets such as images, radio-groups or checkboxes are not searched. The filter function ignores PHANTOM fields, hidden fields and fields defined with the INVISIBLE attribute.

Only rows in memory can be searched. When using page-mode (ON FILL BUFFER), the built-in filter is disabled. When implementing dynamic tree views, the built-in filter will only search the tree nodes available in the program array.

Controlling the reduce filter

The reduce filter can be enabled ("yes") or disabled ("no") with the reduceFilter style attribute:
<Style name="Table">
  <StyleAttribute name="reduceFilter" value= "no" />
</Style>

The reduce filter is enabled by default, when rendering on a mobile device.

See Table.reduceFilter and ScrollGrid.reduceFilter.