ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Table functions
  • Use conditions
  • Benefits of user filters
  • Special cases
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Implements a user filter on a column found in a Table or TreeView Table control. This filter can be disabled by the user or by TableDisableFilter.
The user can delete the filter:
    Example
    // Filters the Company column to display the companies starting with "Fl"
    TableEnableFilter(TABLE_Customer.COL_Company, filterStartsWith, "Fl")
    Syntax
    TableEnableFilter(<Table control.Column> , <Type of filter> , <Filter value>)
    <Table control.Column>: Character string
    Name of the column where the user filter must be enabled. This name has the following format:
    <Table control>.<Column control>
    <Table control> can be a Table or TreeView Table control.
    Example:
    TABLE_CustomerTable.COL_CompanyName
    <Type of filter>: Integer constant
    Type of filter to apply. This filter can be chosen among the following values:
    filterContainsDisplays the rows whose value for the specified column "Contains" the characters specified in <Filter value>.
    filterDifferentDisplays the rows whose value for the specified column "Is different" from the characters specified in <Filter value>.
    filterDoesNotContainDisplays the rows whose value for the specified column "Does not contain" the characters specified in <Filter value>.
    filterDoesNotEndWithDisplays the rows whose value for the specified column "Does not end with" the characters specified in <Filter value>.
    filterDoesNotStartWithDisplays the rows whose value for the specified column "Does not start with" the characters specified in <Filter value>
    filterEndsWithDisplays the rows whose value for the specified column "Ends with" the characters specified in <Filter value>.
    filterEqualDisplays the rows whose value for the specified column "Is equal" to the characters specified in <Filter value>.
    filterGreaterDisplays the rows whose value for the specified column "Is greater than" the characters specified in <Filter value>.
    filterGreaterOrEqualDisplays the rows whose value for the specified column "Is greater than or equal to" the characters specified in <Filter value>.
    filterLessDisplays the rows whose value for the specified column "Is less than" the characters specified in <Filter value>.
    filterLessOrEqualDisplays the rows whose value for the specified column "Is less than or equal to" the characters specified in <Filter value>.
    filterStartsWithDisplays the rows whose value for the specified column "Starts with" the characters specified in <Filter value>.
    <Filter value>: Type corresponding to the filtered column
    Value that must be given to the filter. If this parameter corresponds to an empty string (""), the filter is disabled.
    Remarks

    Use conditions

    This function is available on:
    • a Table or TreeView Table control based on a data file.
    • a Table or TreeView Table control populated programmatically.

    Benefits of user filters

    The user filters can be modified by the end user (unlike a filter implemented by HFilter or the Filter property).

    Special cases

    • If a user filter is already set on the specified column, TableEnableFilter overrides the existing filter and replaces it with the new one.
    • The Filter property cannot be used to identify the current user filter.
    • TableFilteredColumn allows you to identify the user filters (defined by the user or defined with TableEnableFilter).
    Business / UI classification: UI Code
    Component: wd290obj.dll
    Minimum version required
    • Version 12
    This page is also available for…
    Comments
    exemplo tableenablefilter
    https://windevdesenvolvimento.blogspot.com/2021/05/dicas-3324-windev-webdev-mobile.html

    https://youtu.be/CJHIes0-z2w

    // Procura
    TableEnableFilter(COL_Nome,filterContains,EDT_Procura)
    amarildo
    08 May 2021
    FILTAR OBSERVACAO
    TableEnableFilter(TABLE_requisicao.COL_Observacao,filterContains,EDT_oBSERVACAO)

    // BLOG COM VIDEO E EXEMPLO

    http://windevdesenvolvimento.blogspot.com.br/2017/09/aula-1259-tabela-071-enablefilter.html

    https://www.youtube.com/watch?v=tdhRURR9cuE

    De matos
    15 Sep. 2017
    TABLEENABLE FILTER
    Open(WIN_Table_cliente,1)
    //

    PROCEDURE WIN_Table_cliente(_recebe_TIPO_ is int=0)

    IF _recebe_TIPO_=1 THEN
    TableEnableFilter(TABLE_cliente.COL_Tabela_cliente,filterEqual,1)
    ELSE
    IF _recebe_TIPO_=2 THEN
    TableEnableFilter(TABLE_cliente.COL_Tabela_fornecedor,filterEqual,1)

    END
    END

    // BLOG COM VIDEO E EXEMPLO

    http://windevdesenvolvimento.blogspot.com.br/2017/08/aula-1231-windev-curso-erp-045.html


    https://www.youtube.com/watch?v=7q2BUjr7gg8


    De matos
    05 Aug. 2017

    Last update: 06/07/2022

    Send a report | Local help