Reduce filter

The reduce filter allows a user to reduce the row set in a read-only list according to a filter.

When using a DISPLAY ARRAY with a TABLE 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.

Important: This feature is only for mobile platforms.

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 (i.e. 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.

If the rows are filtered (i.e. some value is present in the search field), any non-rowbound action is disabled. On iOS, the action bar is replaced by the search bar.

The list filter is typically used on mobile devices for full-screen list views.

Figure 1. iOS list view with filter field


iOS list view with filter field

Figure 2. Androidâ„¢ list view with filter field


Android list view with filter field