ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage functions / Controls, pages and windows / Table functions
  • Use conditions
  • Benefits of user filters
  • Special cases
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
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 set on a Table or TreeView Table field, the following icon is displayed in the column header:
Funnel
The user can delete the filter:
  • WINDEV via the "Delete the filter" option in the context menu of "funnel" icon. The user filters are included in the AAFs (Automatic Application Features) available for the Table and TreeView Table controls. For more details, see AAF on the columns of a Table control.
  • WEBDEV - Server codeWEBDEV - Browser codePHP via the "Delete the filter" option from the menu opened by clicking the "funnel" icon. User filters are among the available features in Table controls (Browser or AJAX) and TreeView Table controls.
  • AndroidiPhone/iPad by defining a new filter on a column.
Example
// Filtre la colonne Société pour afficher les sociétés commençant par "Fl"
TableEnableFilter(TABLE_Client.COL_Societe, 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:
<Champ Table>.<Champ Colonne>
<Table control> can be a Table or TreeView Table control.
Example:
TABLE_TableClient.COL_NomSociété
<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:
  • Table or TreeView Table controls based on a data file.
  • Table or TreeView Table controls populated programmatically.
WEBDEV - Server codePHP This function is available for Table fields in AJAX mode, Table fields in classic mode and TreeView Table control fields..
WEBDEV - Browser code This function is only available for Table fields in Browser mode.
WEBDEV - Browser code 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 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: wd300obj.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: 09/20/2024

Send a report | Local help