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
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Returns the list of columns filtered by the user in a Table or TreeView Table control.
This filter was implemented:
  • AndroidiPhone/iPad via the "Filter" icon of the context menu of column:
    The context menu of Table controls allows the user to perform several operations on the columns found in the Table controls. For more details, see Context menu of Table controls.
  • programmatically, with the TableEnableFilter function.
Example
// Récupération des filtres
sListeFiltre is string = TableFilteredColumn(TABLE_Client)
FOR EACH STRING sFiltre OF sListeFiltre SEPARATED BY CR
	sCol is string = ExtractString(sFiltre, 1, ";")
	nType is int = ExtractString(sFiltre, 2, ";")
	sVal is string = ExtractString(sFiltre, 3, ";")
	Trace(sCol, nType, sVal)
END
Syntax
<Result> = TableFilteredColumn(<Table control>)
<Result>: Character string
  • List and characteristics of filtered columns.
  • Empty string ("") if no filter is enabled.
The list of filtered columns has the following format:
<Filtered column 1>; <Type of filter 1>; <Filter value 1> + RC +... +
<Filtered column N> ; <Type of filter N> ; <Filter value N>
where:
  • <Filtered column X> corresponds to the name of the filtered column.
  • <Type of filter> corresponds to the type of filter selected by the user. The available types are as follows:
    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> corresponds to the value of the filter selected by the user.
<Table control>: Control name
Name of the Table or TreeView Table control used.
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.
Component: wd300obj.dll
Minimum version required
  • Version 18
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/28/2025

Send a report | Local help