|
|
|
|
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 "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.
// 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 page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|