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.
Note: These filter options are also available for the TreeView Table controls.
How to proceed?

Filter on a column

This features is automatically implemented in the memory Table controls and in the browsing Table controls, for the columns with search (magnifier displayed in the column). All you have to do is right-click the magnifier to display the popup menu of column:
For managing the 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
    Note: The "Is empty" condition is used to filter the column on the empty elements.
    New in version 18
    Note: The "Is empty" condition is used to filter the column on the empty elements.
    Note: The "Is empty" condition is used to filter the column on the empty elements.
  • to implement a filter with one of the values found in the column.
  • to delete a filter that was previously implemented on the column ("Delete the filter").
  • Versions 17 and later
    to store the filters ("Store the 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 implemented.
      • 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 is not locking and it can be closed via a simple click.
        New in version 23
        The toast is not locking and it can be closed via a simple click.
        The toast is not locking and it can be closed via a simple click.
    New in version 17
    to store the filters ("Store the 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 implemented.
      • 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 is not locking and it can be closed via a simple click.
        New in version 23
        The toast is not locking and it can be closed via a simple click.
        The toast is not locking and it can be closed via a simple click.
    to store the filters ("Store the 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 implemented.
      • 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 is not locking and it can be closed via a simple click.
        New in version 23
        The toast is not locking and it can be closed via a simple click.
        The toast is not locking and it can be closed via a simple click.
Notes:
  • The popup menu displayed during a right click on the column title differs from the one displayed during a right click on the magnifier. 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.
Caution: The filtering performed by the user via the interface may not be known by programming.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, use DisableAAF associated with the aafFilter constant.To avoid proposing the popup menu for implementing a search and a filter on the columns, all you have to do is use AAFDisable (or DisableAAF) associated with the aafFilter constant.
Versions 17 and later

Storing filters

..StoreFilterAAF is used to find out and specify whether the filters implemented by the user on a Table control are stored 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.
Versions 19 and later
To avoid proposing the "Store the filters" and "Store the sorts" options in the popup menu, all you have to do is use DisableAAF associated with the aafSaveFilterAndSort constant.
New in version 19
To avoid proposing the "Store the filters" and "Store the sorts" options in the popup menu, all you have to do is use DisableAAF associated with the aafSaveFilterAndSort constant.
To avoid proposing the "Store the filters" and "Store the sorts" options in the popup menu, all you have to do is use DisableAAF associated with the aafSaveFilterAndSort constant.To avoid proposing the "Store the filters" and "Store the sorts" options in the popup menu, all you have to do is use AAFDisable (or DisableAAF) associated with the aafSaveFilterAndSort constant.
New in version 17

Storing filters

..StoreFilterAAF is used to find out and specify whether the filters implemented by the user on a Table control are stored 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.
Versions 19 and later
To avoid proposing the "Store the filters" and "Store the sorts" options in the popup menu, all you have to do is use DisableAAF associated with the aafSaveFilterAndSort constant.
New in version 19
To avoid proposing the "Store the filters" and "Store the sorts" options in the popup menu, all you have to do is use DisableAAF associated with the aafSaveFilterAndSort constant.
To avoid proposing the "Store the filters" and "Store the sorts" options in the popup menu, all you have to do is use DisableAAF associated with the aafSaveFilterAndSort constant.To avoid proposing the "Store the filters" and "Store the sorts" options in the popup menu, all you have to do is use AAFDisable (or DisableAAF) associated with the aafSaveFilterAndSort constant.

Storing filters

..StoreFilterAAF is used to find out and specify whether the filters implemented by the user on a Table control are stored 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.
Versions 19 and later
To avoid proposing the "Store the filters" and "Store the sorts" options in the popup menu, all you have to do is use DisableAAF associated with the aafSaveFilterAndSort constant.
New in version 19
To avoid proposing the "Store the filters" and "Store the sorts" options in the popup menu, all you have to do is use DisableAAF associated with the aafSaveFilterAndSort constant.
To avoid proposing the "Store the filters" and "Store the sorts" options in the popup menu, all you have to do is use DisableAAF associated with the aafSaveFilterAndSort constant.To avoid proposing the "Store the filters" and "Store the sorts" options in the popup menu, all you have to do is use AAFDisable (or DisableAAF) associated with the aafSaveFilterAndSort constant.
See also
Minimum version required
  • Version 12
Comments
Click [Add] to post a comment