|
|
|
|
|
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 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.
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:
| | 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: - Table or TreeView Table controls based on a data file.
- Table or TreeView Table controls populated programmatically.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|