ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Table functions
  • Use conditions
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
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 popup 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.
  • through programming with TableEnableFilter.
Example
// Get the filters
sFilterList is string = TableFilteredColumn(TABLE_Customer)
FOR EACH STRING sFilter OF sFilterList SEPARATED BY CR
sCol is string = ExtractString(sFilter, 1, ";")
nType is int = ExtractString(sFilter, 2, ";")
sVal is string = ExtractString(sFilter, 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:
  • a Table or TreeView Table control based on a data file.
  • a Table or TreeView Table control populated programmatically.
Component: wd290obj.dll
Minimum version required
  • Version 18
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/07/2022

Send a report | Local help