AAF: Sort/Search/Filter on the columns of Table controls

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

Editors

AAF (Automatic Application Features)

AAF on Tables/TreeView Tables

AAF: Sort/Search/Filter on the columns of Table controls

Overview

See also

AAF: Chart on a table column

AAF: Exporting data (Table, TreeView Table, Looper, TreeView...)

AAF: Sort on the columns of a Table control

AAF: Sort/Search/Filter on the columns of Table controls

AAF: Zoom the content of a control (Table, Spreadsheet, List box, Pivot table, ...)

Automatic calculations in a Table control (AAF)

Automatic menu of tables (AAF)

Coloring a row, a column or a cell found in a control (AAF)

Context menu of Check Box columns (AAF)

Printing the content of a TreeView Table (AAF)

Printing the content of a table (AAF)

Storing the breaks in the Table/Looper controls (AAF)

Overview

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

AAF: Sort/Search/Filter on the columns of Table controls

Overview

In the memory and browsing Table controls, the columns with search (magnifier displayed in the column) are used to display a popup menu allowing you to specify the characteristics of the sort, filter or search that will be performed on the column.

Simply right-click the magnifier to open the context menu of the column:

This popup menu proposes:

to perform a search ("Find" option):
All you have to do is type the first letters corresponding to the sought element. The Table control displays all the elements corresponding to the first letters typed.
to implement a filter ("Filter"):
To do so, select a condition and type the requested value. The content of the Table control is filtered according to the specified condition.
Remark: The "Is empty" condition is used to display only empty elements in the column.
to delete a filter that was previously set on the column ("Delete filter").
to remember filters ("Remember filters").
If this option is enabled, the filters implemented when closing the window will be automatically run during the next window opening. A short message will be displayed to inform the user and to indicate the filters that are set.
to remember sorts ("Remember sorts").
If this option is enabled, the sorts defined when the window is closed will be automatically set next time the window is opened.
to set a filter with one of the values in the column.

Remarks:

The popup menus displayed after right-clicking the column title and the magnifier are different.
These options are also available for the TreeView Table controls.
For more details on the options of this context menu, see Context menu of columns.