Filters in Table fields linked to a data file

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / Developing an application or website / Controls, windows and pages / Controls: Available types / Table control / Data-bound Table

Overview
Describing the Table control
"Use HFilter to browse the file" option unchecked
"Use HFilter to browse the file" option checked
Filter property
HFilter

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Filters in Table fields linked to a data file

Overview

WINDEV, WEBDEV and WINDEV Mobile include multiple methods to filter the records displayed in a data-bound Table control:

Filter on the search key, defined in the description window of the Table control.
Filter property.
HFilter function.
Optional event for filtering the records of a Table control. For more details, see Table control events.

Describing the Table control

The "Display the records whose browse item starts with" option allows you to set a filter on a data-bound Table control.

The filter has the following characteristics:

"Starts with" filter. The condition is directly entered in the editor.
The filter is only applied to data-bound Table controls.
The filter does not affect how the data file is read (HReadFirst, etc.)

"Use HFilter to browse the file" option unchecked

If "Use HFilter to browse the file" is unchecked, the filter will have the following characteristics:

"Starts with" filter. The condition is directly entered in the editor.
The filter is only applied to data-bound Table controls.
The filter does not affect how the data file is read (HReadFirst, etc.)
Only the column bound to the browse item can be sorted ("Sortable" option in the "General tab").
The user will not be able to perform searches in the Table control ("Search/filter" option in the "General" tab).

Note: Filter options are not available for Table based on a data file fields.

"Use HFilter to browse the file" option checked

If "Use HFilter to browse the file" is checked, the filter will have the following characteristics:

"Starts with" filter. The condition is directly entered in the editor.
The filter is only applied to data-bound Table controls.
The filter does not affect how the data file is read (HReadFirst, etc.)
The user will be able to sort the data displayed in the columns bound to key items ("Sortable" option in the "General" tab).
The user will be able to perform searches in the columns bound to key items ("Search/filter" option in the "General" tab).

Special case Before opening the window containing the Table control, if a filter has been defined by function HFilter on the field's base file, the Table control will automatically filter the records displayed (filter entered directly in the editor or by property Filter). When the window is closed, no filters will be enabled on the data file.

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

Note: Filter options are not available for Table based on a data file fields.

Filter property

The Filter property can be used to dynamically set the characteristics of the filter applied to the Table control.

The filter applied uses the "Use HFilter to browse the file" option defined in the editor.

HFilter

HFilter filters the base file of the 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 the Table control, it is necessary to redisplay the contents of the Table control using TableDisplay.

Note When a data-bound Table control is automatically filled (by WINDEV, WEBDEV or WINDEV Mobile), the Table control is not yet filled when the initialization code is executed. The records can be filtered with HFilter.