PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Use conditions
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
Returns the list of columns filtered by the user in a Table or TreeView Table control.
This filter was implemented:
  • WINDEV via the popup menu of the "magnifier" icon of column. 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.
  • Versions 20 and later
    AndroidiPhone/iPad via the "Filter" icon of the popup menu of column:
    The popup menu of Table controls allows the user to perform several operations on the columns found in the Table controls. See Popup menu of Table controls for more details.
    New in version 20
    AndroidiPhone/iPad via the "Filter" icon of the popup menu of column:
    The popup menu of Table controls allows the user to perform several operations on the columns found in the Table controls. See Popup menu of Table controls for more details.
    AndroidiPhone/iPad via the "Filter" icon of the popup menu of column:
    The popup menu of Table controls allows the user to perform several operations on the columns found in the Table controls. See Popup menu of Table controls for more details.
  • WEBDEV - Server code via the menu opened by clicking the "Magnifier" icon found in the header of the column. The user filters are included in the features available for the Table Ajax controls and for the TreeView Table controls.
  • by programming with TableEnableFilter.
Versions 19 and later
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
WEBDEV - Server codeWindows This function is available in WEBDEV Server for the Ajax Table controls.
New in version 19
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
WEBDEV - Server codeWindows This function is available in WEBDEV Server for the Ajax Table controls.
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
WEBDEV - Server codeWindows This function is available in WEBDEV Server for the Ajax Table controls.
Versions 20 and later
Android This function is now available for the Android applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 20
Android This function is now available for the Android applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Android This function is now available for the Android applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
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:
<Name of Filtered Column 1> ; <Type of Filter 1> ; <Value of Filter 1> + CR + ... +
<Name of Filtered Column N> ; <Type of Filter N> ; <Value of Filter N>
where:
  • <Name of 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:
    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> corresponds to the value of the filter selected by the user.
<Table Control>: Control name
Name of Table or TreeView Table control used.
Remarks

Use conditions

This function is available for a memory or browsing control.
WEBDEV - Server code This function is available for the Ajax Table controls and for the TreeView Table controls.
AndroidiPhone/iPad The TreeView Table control is not available.
Components
WINDEVReports and Queries wd230obj.dll
WEBDEV - Server code wd230page.dll
Linux wd230obj.so
Android wd230android.jar
Minimum required version
  • Version 18
This page is also available for…
Comments
Click [Add] to post a comment