TableFilteredColumn (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

WLanguage functions

Controls, pages and windows

Table functions

Prefix syntax

TableFilteredColumn

Presentation

Example

Use conditions

See also

ToExcel

BuildBrowsingTable (Example)

BuildBrowsingTable

Constants for managing Table, Treeview Table, Looper and List Box controls

FileToMemoryTable

Table control functions

TableAdd

TableAddColumn

TableAddInProgress

TableAddLine

TableAddLineWithAnimation

TableAddTitleHeader

TableAdjust

TableBreakIndex (Example)

TableBreakIndex

TableCellSelect

TableCellSelectOccurrence

TableCollapseExpand

TableColumnIndex

TableColumnSelect

TableColumnSelectOccurrence

TableCount

TableDelete

TableDeleteAll

TableDeleteSelect

TableDeleteWithAnimation

TableDisableFilter

TableDisplay

TableEnableFilter

TableEnd

TableEndFilling

TableEnumBreak

TableEnumColumn

TableFilteredColumn

TableFixColumn

TableFormulaAdd

TableFormulaDeleteAll

TableInfoXY (Example)

TableInfoXY

TableInputInProgress

TableInputSearch

TableInsert

TableInsertColumn

TableInsertLine

TableInsertLineWithAnimation

TableMode

TableModify

TableModifyColumn

TableModifyLine

TableMoveColumn

TableMoveLine

TablePosition

TablePrint

TableRecNum

TableRefreshVisible

TableRestorePositionAndSelection

TableSave

TableSavePositionAndSelection

TableSearch

TableSearchEverywhere

TableSelect

TableSelectCount

TableSelectMinus

TableSelectPlus

TableSelectToFile

TableSetFocus

TableSort

TableSortedColumn

TableStartFilling

TableSwapLine

TableToClipboard

TableToExcel

TableToText

TableToWord

TableToXML

Use conditions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

TableFilteredColumn (Function)

In french: TableColonnesFiltrées

Returns the list of columns filtered by the user in a Table or TreeView Table control.

This filter was implemented:

via the context 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. For more details, see AAF on the columns of a Table control.
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.
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 Ajax Table controls and for the TreeView 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:
filterContains Displays the rows whose value for the specified column "Contains" the characters specified in <Filter value>.
filterDifferent Displays the rows whose value for the specified column "Is different" from the characters specified in <Filter value>.
filterDoesNotContain Displays the rows whose value for the specified column "Does not contain" the characters specified in <Filter value>.
filterDoesNotEndWith Displays the rows whose value for the specified column "Does not end with" the characters specified in <Filter value>.
filterDoesNotStartWith Displays the rows whose value for the specified column "Does not start with" the characters specified in <Filter value>
filterEndsWith Displays the rows whose value for the specified column "Ends with" the characters specified in <Filter value>.
filterEqual Displays the rows whose value for the specified column "Is equal" to the characters specified in <Filter value>.
filterGreater Displays the rows whose value for the specified column "Is greater than" the characters specified in <Filter value>.
filterGreaterOrEqual Displays the rows whose value for the specified column "Is greater than or equal to" the characters specified in <Filter value>.
filterLess Displays the rows whose value for the specified column "Is less than" the characters specified in <Filter value>.
filterLessOrEqual Displays the rows whose value for the specified column "Is less than or equal to" the characters specified in <Filter value>.
filterStartsWith Displays 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.

This function is available for Ajax Table controls and TreeView Table controls.

Component: wd280obj.dll