Filters in the browsing Table controls

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

Editors

Controls (window/page/report)

Controls

Table control

Browsing table

Filters in the browsing Table controls

Overview

Describing the Table control

..Filter property

HFilter

See also

Filters in the browsing Table controls

Overview

WINDEV, WEBDEV and WINDEV Mobile propose several methods to filter the records displayed in a browsing Table control:

Filter on the search key, defined in the description window of the Table control.
..Filter.
HFilter.
Optional process for filtering the records of a Table control. See Processes associated with the Table controls for more details.

Versions 20 and later

The Table control is now available for the Android applications.

The Table control is now available for the iPhone/iPad applications.

New in version 20

The Table control is now available for the Android applications.

The Table control is now available for the iPhone/iPad applications.

The Table control is now available for the Android applications.

The Table control is now available for the iPhone/iPad applications.

Describing the Table control

The option "Display the records whose search key starts with" is used to describe a filter on a browsing Table control.

The filter has the following characteristics:

"Starts with" filter. The condition is directly entered in the editor.
Filter for the display of the browsing Table controls.
Filter not affecting the browse of data file (HReadFirst, ...).

"Use HFilter to browse the file" option unchecked

If the option "Use HFilter to browse the file" is unchecked, the filter has the following characteristics:

"Starts with" filter. The condition is directly entered in the editor.
Filter for the display of the browsing Table controls.
Filter not affecting the browse of data file (HReadFirst, ...)
Only the column associated with the search item can be sorted ("Sortable" option in the "General" tab).
No search can be performed by the user in the Table control ("Searchable" option in the "General" tab).

Note: The filtering options are not available for the browsing Table controls with direct access.

"Use HFilter to browse the file" option checked

If the option "Use HFilter to browse the file" is checked, the filter has the following characteristics:

"Starts with" filter. The condition is directly entered in the editor.
Filter for the display of the browsing Table controls.
Filter affecting the browse of data file (HReadFirst, ...).
The user will be able to sort the information displayed in the columns associated with key items ("Sortable" option in the "General" tab).
The user will be able to perform searches in the columns associated with key items ("Searchable" option in the "General" tab).

Special case: Before opening the window containing the Table control, a filter was defined by HFilter on the base file of control. The Table control automatically filters the records displayed (filter directly entered in the editor or with the ..Filter property). When the closing window, no filter will be enabled on the data file.

Caution: Check which filter is active when browsing the files. As two filters cannot be enabled at the same time, only the last filter created by HFilter is stored.

Note: The filtering options are not available for the browsing Table controls with direct access.

..Filter property

..Filter is used to dynamically configure the characteristics of the filter applied to the Table control.

The applied filter takes into account the option "Also filter the file (HFilter)" defined in the editor.

HFilter

HFilter is used to filter the base file of Table control. HFilter allows you to use all types of filters (including the "Starts with" filters).

If HFilter is not used in the initialization code of Table control, the content of Table control must be re-displayed by TableDisplay.

Note: When a browsing Table control is automatically filled (by WINDEV, WEBDEV or WINDEV Mobile), the Table control is not filled when running the initialization code. The records can be filtered by HFilter.