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