PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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 (with or without quotes)
    Name of the column where the user filter must be enabled. This name has the following format:
    <Name of Table control>.<Column name>
    <Name of Table control> can correspond to the name of 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:
    filterStartsWithDisplays the rows whose value for the specified column "Starts with" the characters specified in <Filter value>.
    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 "Differs" from the characters specified in <Filter value>.
    filterEqualDisplays the rows whose value for the specified column "Is equal" to 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>.
    filterLessDisplays the rows whose value for the specified column "Is less than" 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>
    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>.
    filterGreaterOrEqualDisplays the rows whose value for the specified column "Is greater than or 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>.
    filterEndsWithDisplays the rows whose value for the specified column "Ends 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 for a memory or browsing control.

    Benefits of user filters

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

    Special cases

    • If a user filter is already enabled on the specified column, TableEnableFilter cancels the existing filter and replaces it by the new one.
    • ..Filter does not allow you to find out the user filter used.
    • Versions 18 and later
      TableFilteredColumn allows you to find out the user filters (defined by the user directly or by TableEnableFilter).
      New in version 18
      TableFilteredColumn allows you to find out the user filters (defined by the user directly or by TableEnableFilter).
      TableFilteredColumn allows you to find out the user filters (defined by the user directly or by TableEnableFilter).
    Component : wd240obj.dll
    Minimum version required
    • Version 12
    This page is also available for…
    Comments
    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