PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • 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.
WINDEVWEBDEV - Server codeWEBDEV - Browser codePHP Note: When a user filter is defined on a Table or TreeView Table control, the following icon is displayed in the column header:
Funnel
The user can delete the filter:
  • WINDEV via the "Delete the filter" option from the popup menu of "funnel" icon. The user filters are included in the AAFs (Automatic Application Features) available for the Table and TreeView Table controls. See AAF on the columns of a Table control for more details.
  • WEBDEV - Server codeWEBDEV - Browser codePHP via the "Delete the filter" option from the menu opened by clicking the "funnel" icon. The user filters are included in the features available for the Table controls (Browser or Ajax) and for the TreeView Table controls.
  • Versions 20 and later
    AndroidiPhone/iPad by defining a new filter on a column.
    New in version 20
    AndroidiPhone/iPad by defining a new filter on a column.
    AndroidiPhone/iPad by defining a new filter on a column.
Versions 15 and later
PHP This function is now available for the PHP sites.
New in version 15
PHP This function is now available for the PHP sites.
PHP This function is now available for the PHP sites.
Versions 16 and later
WINDEVLinux This function is now available for the WINDEV applications in Linux.
New in version 16
WINDEVLinux This function is now available for the WINDEV applications in Linux.
WINDEVLinux This function is now available for the WINDEV applications in Linux.
Versions 19 and later
WEBDEV - Browser code This function is now available in Browser code for the Browser Table controls.
New in version 19
WEBDEV - Browser code This function is now available in Browser code for the Browser Table controls.
WEBDEV - Browser code This function is now available in Browser code for the Browser Table controls.
Versions 20 and later
WINDEV MobileAndroid This function is now available for the Android applications.
WINDEV MobileiPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 20
WINDEV MobileAndroid This function is now available for the Android applications.
WINDEV MobileiPhone/iPad This function is now available for the iPhone/iPad applications.
WINDEV MobileAndroid This function is now available for the Android applications.
WINDEV MobileiPhone/iPad This function is now available for the iPhone/iPad applications.
Example
// Filters the Company column to display the companies starting with "Fl"
TableEnableFilter(TABLE_Customer.COL_Company, filterStartsWith, "Fl")
Syntax
TableEnableFilter(<Table Name.Column Name> , <Type of Filter> , <Filter Value>)
<Table Name.Column Name>: Character string (with or without quotes)
Name of the column where the user filter must be enabled. This name has the following format:
<Table Name>.<Column Name>
<Table Name> 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.
WEBDEV - Server codePHP This function is available for the Ajax Table controls, the Classic Table controls and the TreeView Table controls.
WEBDEV - Browser code This function is available for the browser Table controls only.
WEBDEV - Browser codeAndroidiPhone/iPad The TreeView Table control is not available.

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).
Components
WINDEVReports and Queries wd230obj.dll
WEBDEV - Server code wd230page.dll
WEBDEV - Browser code WDJS.DLL
Linux wd230obj.so
Android wd230android.jar
Minimum required version
  • 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
Sep. 15 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
Aug. 05 2017