PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Overview
  • How to proceed?
  • Filter on a column
  • Managing the filters by programming
  • Proposing a filter by programming
  • Don't propose the popup menu for implementing a filter on the columns
  • Storing filters
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
The user can filter the content of a Table control by displaying the records corresponding to a condition for example.
Remark: These filter options are also available for TreeView Table controls.
How to proceed?

Filter on a column

This feature is automatically implemented in memory Table controls and in browsing Table controls, for columns with search (magnifier displayed in the column). Simply right-click the magnifier to display the popup menu of the column:
For managing filters, this popup menu proposes:
  • to implement a filter ("Filter"):
    To do so, select a condition and type the requested value. The content of Table control is filtered according to the specified condition.
    Versions 18 and later
    Remark: The "Is empty" condition is used to display only empty elements in the column.
    New in version 18
    Remark: The "Is empty" condition is used to display only empty elements in the column.
    Remark: The "Is empty" condition is used to display only empty elements in the column.
  • to set a filter with one of the values in the column.
  • to delete a filter that was previously set on the column ("Delete filter").
  • Versions 17 and later
    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.
      • Versions 23 and later
        The display duration of this message can be configured by AAFConfigure.
        New in version 23
        The display duration of this message can be configured by AAFConfigure.
        The display duration of this message can be configured by AAFConfigure.
      • Versions 23 and later
        The toast does not lock the application and can be closed with a simple click.
        New in version 23
        The toast does not lock the application and can be closed with a simple click.
        The toast does not lock the application and can be closed with a simple click.
    New in version 17
    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.
      • Versions 23 and later
        The display duration of this message can be configured by AAFConfigure.
        New in version 23
        The display duration of this message can be configured by AAFConfigure.
        The display duration of this message can be configured by AAFConfigure.
      • Versions 23 and later
        The toast does not lock the application and can be closed with a simple click.
        New in version 23
        The toast does not lock the application and can be closed with a simple click.
        The toast does not lock the application and can be closed with a simple click.
    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.
      • Versions 23 and later
        The display duration of this message can be configured by AAFConfigure.
        New in version 23
        The display duration of this message can be configured by AAFConfigure.
        The display duration of this message can be configured by AAFConfigure.
      • Versions 23 and later
        The toast does not lock the application and can be closed with a simple click.
        New in version 23
        The toast does not lock the application and can be closed with a simple click.
        The toast does not lock the application and can be closed with a simple click.
Remarks:
  • The popup menus displayed after right-clicking the column title and the magnifier are different. See Popup menu of columns for more details.
  • In a multilingual application, you have the ability to translate the popup menu, see Configuring the menus of AAFs.
Managing the filters by programming

Proposing a filter by programming

TableEnableFilter is used to create a filter on a column by programming. This filter can be disabled by TableDisableFilter.
TableFilteredColumn returns the list of columns filtered by the user.

Don't propose the popup menu for implementing a filter on the columns

To avoid proposing the popup menu for implementing a search and a filter on the columns, simply use AAFDisable (or DisableAAF) with the aafFilter constant.
Versions 17 and later

Storing filters

..StoreFilterAAF is used to find out and specify whether the filters set on a Table control by the user are kept between 2 application launches.
Versions 23 and later
AAFConfigure associated with the aafToastDurationRestoreFilter constant is used to modify the display duration of the toast indicating the implemented filters to the user.
New in version 23
AAFConfigure associated with the aafToastDurationRestoreFilter constant is used to modify the display duration of the toast indicating the implemented filters to the user.
AAFConfigure associated with the aafToastDurationRestoreFilter constant is used to modify the display duration of the toast indicating the implemented filters to the user.
To avoid proposing the "Remember filters" and "Remember sorts" options in the popup menu, simply use AAFDisable (or DisableAAF) with the aafSaveFilterAndSort constant.
New in version 17

Storing filters

..StoreFilterAAF is used to find out and specify whether the filters set on a Table control by the user are kept between 2 application launches.
Versions 23 and later
AAFConfigure associated with the aafToastDurationRestoreFilter constant is used to modify the display duration of the toast indicating the implemented filters to the user.
New in version 23
AAFConfigure associated with the aafToastDurationRestoreFilter constant is used to modify the display duration of the toast indicating the implemented filters to the user.
AAFConfigure associated with the aafToastDurationRestoreFilter constant is used to modify the display duration of the toast indicating the implemented filters to the user.
To avoid proposing the "Remember filters" and "Remember sorts" options in the popup menu, simply use AAFDisable (or DisableAAF) with the aafSaveFilterAndSort constant.

Storing filters

..StoreFilterAAF is used to find out and specify whether the filters set on a Table control by the user are kept between 2 application launches.
Versions 23 and later
AAFConfigure associated with the aafToastDurationRestoreFilter constant is used to modify the display duration of the toast indicating the implemented filters to the user.
New in version 23
AAFConfigure associated with the aafToastDurationRestoreFilter constant is used to modify the display duration of the toast indicating the implemented filters to the user.
AAFConfigure associated with the aafToastDurationRestoreFilter constant is used to modify the display duration of the toast indicating the implemented filters to the user.
To avoid proposing the "Remember filters" and "Remember sorts" options in the popup menu, simply use AAFDisable (or DisableAAF) with the aafSaveFilterAndSort constant.
See also
Minimum version required
  • Version 12
Comments
Click [Add] to post a comment