Namespace: Consultingwerk.Windows.Util
Class 
UltraGridFilterRowHelper Copy to Clipboard
Parent classes:
Progress.Lang.Object
Consultingwerk.Windows.Util.UltraGridFilterRowHelper

Inherits: Progress.Lang.Object


Navigate to: Methods | Constructors | Events | Properties | ProDatasets | Temp-Tables



Top Method Summary
Options Name Purpose
BuildMultipleValueQueryExpression (UltraGrid, UltraGridColumn, character, character, ListQueryExpressionByTable) Builds the query expression for a filter cell with the selection of multiple values
BuildQueryExpression (UltraGrid, ListQueryExpressionByTable) Returns an Array of IQueryExpression objects
BuildQueryExpression (UltraGrid, ListQueryExpressionByTable, logical) Returns an Array of IQueryExpression objects
BuildQueryExpression (UltraGrid, ListQueryExpressionByTable, logical, logical) Returns an Array of IQueryExpression objects
BuildQueryExpression (UltraGrid, ListQueryExpressionByTable, logical, logical, character) Returns an Array of IQueryExpression objects
Consultingwerk.QueryExpression BuildQueryExpressionForField (UltraGrid, character, IQueryExpression, ListQueryExpressionByTable, OperatorEnum) Builds a QueryExpression for a single grid filter field
Consultingwerk.IQueryExpression CreateValueHolder (UltraGridColumn, character) Returns the holder object for a value of a filter cell with the selection of multiple values
LOGICAL EnableMultipleValueFilter (UltraGrid, UltraGridColumn) Allows the selection of multiple values in the filter cell of a column
Infragistics.Win.UltraWinGrid.FilterComparisionOperator FilterComparisionOperatorFromOperator (character) Returns the UltraGrid FilterComparisionOperator matching the ABL filter operator
InitializeSupportedFilterOperators (UltraGrid) Initializes the supported filter operators
InitializeSupportedFilterOperators (UltraGrid, character) Initializes the supported filter operators
Consultingwerk.OperatorEnum OperatorEnumFromOperator (character) Returns the UltraGrid FilterComparisionOperator matching the ABL filter operator
Consultingwerk.OperatorEnum OperatorFromList (character, character) Returns the operator for the given column from the list
Consultingwerk.OperatorEnum OperatorFromUltraGrid (FilterComparisionOperator) Returns the OperatorEnum matching the UltraGridFilterCell FilterOperator

Top Constructor Summary
Options Name Purpose
UltraGridFilterRowHelper () Disallow instance creation


Method Detail
Top

BuildMultipleValueQueryExpression (UltraGrid, UltraGridColumn, character, character, ListQueryExpressionByTable)
Purpose: Builds the query expression for a filter cell with the selection of
multiple values
Notes: SCL-6037 - an OR-group of equality predicates, one per selected value

Parameters:
poGrid Infragistics.Win.UltraWinGrid.UltraGrid
The source grid
poColumn Infragistics.Win.UltraWinGrid.UltraGridColumn
The column of the filter cell
pcValues CHARACTER
The delimited list of the selected (data) values
pcDelimiter CHARACTER
The delimiter of the selected values
poListQueryExpressions Consultingwerk.ListQueryExpressionByTable
The list of query operators per tables the expression will be added to
Top

BuildQueryExpression (UltraGrid, ListQueryExpressionByTable)
Purpose: Returns an Array of IQueryExpression objects
Notes: Defaults to BuildQueryExpression (poGrid, poListQueryExpressions, FALSE, FALSE)

Parameters:
poGrid Infragistics.Win.UltraWinGrid.UltraGrid
The source grid
poListQueryExpressions Consultingwerk.ListQueryExpressionByTable
The list of query operators per tables the expression will be added to
Top

BuildQueryExpression (UltraGrid, ListQueryExpressionByTable, logical)
Purpose: Returns an Array of IQueryExpression objects
Notes: MATCHES uses a flexible combination with BEGINS based on entered text
or BEGINS for character fields
Defaults to BuildQueryExpression (poGrid, poListQueryExpressions, plUseMatches, FALSE)

Parameters:
poGrid Infragistics.Win.UltraWinGrid.UltraGrid
The source grid
poListQueryExpressions Consultingwerk.ListQueryExpressionByTable
The list of query operators per tables the expression will be added to
plUseMatches LOGICAL
Logical value indicating if MATCHES should be used for Character fields
Top

BuildQueryExpression (UltraGrid, ListQueryExpressionByTable, logical, logical)
Purpose: Returns an Array of IQueryExpression objects
Notes: MATCHES uses a flexible combination with BEGINS based on entered text
or BEGINS for character fields
Supported UltraGrid FilterOperators per data type (plUseOperators = TRUE):
LOGICAL: Equals, NotEquals
DATE, DATETIME, DATETIME-TZ, Equals, NotEquals, GreaterThan, GreaterThanOrEqualTo,
DECIMAL, INTEGER, INT64: LessThan, LessThanOrEqualTo
CHARACTER, LONGCHAR: Equals, NotEquals, StartsWith, Like, EndsWith,
GreaterThan, GreaterThanOrEqualTo, LessThan, LessThanOrEqualTo

Parameters:
poGrid Infragistics.Win.UltraWinGrid.UltraGrid
The source grid
poListQueryExpressions Consultingwerk.ListQueryExpressionByTable
The list of query operators per tables the expression will be added to
plUseMatches LOGICAL
Logical value indicating if MATCHES should be used for Character fields
plUseOperators LOGICAL
Logical value indicating if the actual filter operator of the filter cell shall be used or a default operator (BEGINS, GE) shall be assumed
Top

BuildQueryExpression (UltraGrid, ListQueryExpressionByTable, logical, logical, character)
Purpose: Returns an Array of IQueryExpression objects
Notes: MATCHES uses a flexible combination with BEGINS based on entered text
or BEGINS for character fields
Supported UltraGrid FilterOperators per data type (plUseOperators = TRUE):
LOGICAL: Equals, NotEquals
DATE, DATETIME, DATETIME-TZ, Equals, NotEquals, GreaterThan, GreaterThanOrEqualTo,
DECIMAL, INTEGER, INT64: LessThan, LessThanOrEqualTo
CHARACTER, LONGCHAR: Equals, NotEquals, StartsWith, Like, EndsWith,
GreaterThan, GreaterThanOrEqualTo, LessThan, LessThanOrEqualTo

Parameters:
poGrid Infragistics.Win.UltraWinGrid.UltraGrid
The source grid
poListQueryExpressions Consultingwerk.ListQueryExpressionByTable
The list of query operators per tables the expression will be added to
plUseMatches LOGICAL
Logical value indicating if MATCHES should be used for Character fields
plUseOperators LOGICAL
Logical value indicating if the actual filter operator of the filter cell shall be used or a default operator (BEGINS, GE) shall be assumed
pcOperators CHARACTER
The list of operators to use when plUseOperators is false, comma delimited list of field=operator pairs
Top

Consultingwerk.QueryExpression BuildQueryExpressionForField (UltraGrid, character, IQueryExpression, ListQueryExpressionByTable, OperatorEnum)
Purpose: Builds a QueryExpression for a single grid filter field
Notes:

Parameters:
poGrid Infragistics.Win.UltraWinGrid.UltraGrid
The source grid
pcKey CHARACTER
The key of the current column
poHolder Consultingwerk.IQueryExpression
The holder class for the field value
poListQueryExpressions Consultingwerk.ListQueryExpressionByTable
The list of query operators per tables the expression will be added to
poOperator Consultingwerk.OperatorEnum
The operator to use
Returns Consultingwerk.QueryExpression
The Consultingwerk.QueryExpression for the specified filter field
Top

Consultingwerk.IQueryExpression CreateValueHolder (UltraGridColumn, character)
Purpose: Returns the holder object for a value of a filter cell with the
selection of multiple values
Notes: SCL-6037 - the value is the string representation of the data value
of the value list item (System.Object:ToString ())

Parameters:
poColumn Infragistics.Win.UltraWinGrid.UltraGridColumn
The column of the filter cell
pcValue CHARACTER
The string representation of the data value
Returns Consultingwerk.IQueryExpression
The holder object for the value
Top

LOGICAL EnableMultipleValueFilter (UltraGrid, UltraGridColumn)
Purpose: Allows the selection of multiple values in the filter cell of a column
Notes: SCL-6037 - assigns an UltraComboEditor configured as a checked list
(CheckedListDataFilter) as the editor of the filter cell and copies
the items from the ValueList of the column or from the
UltraComboEditor used as the editor of the column. Repeated calls
refresh the items (e.g. after a Business Entity combo box has
retrieved its values) and keep the selected values. The editor of
the column (cell editing) is not changed.

Parameters:
poGrid Infragistics.Win.UltraWinGrid.UltraGrid
The UltraGrid
poColumn Infragistics.Win.UltraWinGrid.UltraGridColumn
The column to allow the selection of multiple filter values for
Returns LOGICAL
Logical value indicating if the column provides values to select from
Top

Infragistics.Win.UltraWinGrid.FilterComparisionOperator FilterComparisionOperatorFromOperator (character)
Purpose: Returns the UltraGrid FilterComparisionOperator matching the ABL filter
operator
Notes: Supported UltraGrid FilterOperators per data type (plUseOperators = TRUE):
LOGICAL: Equals, NotEquals
DATE, DATETIME, DATETIME-TZ, Equals, NotEquals, GreaterThan, GreaterThanOrEqualTo,
DECIMAL, INTEGER, INT64: LessThan, LessThanOrEqualTo
CHARACTER, LONGCHAR: Equals, NotEquals, StartsWith, Like, EndsWith,
GreaterThan, GreaterThanOrEqualTo, LessThan, LessThanOrEqualTo

Parameters:
pcOperatorString CHARACTER
The query operator string
Returns Infragistics.Win.UltraWinGrid.FilterComparisionOperator
The resulting FilterComparisionOperator value
Top

InitializeSupportedFilterOperators (UltraGrid)
Purpose: Initializes the supported filter operators
Notes: Values depend on the Column's data types

Parameters:
poGrid Infragistics.Win.UltraWinGrid.UltraGrid
The source grid
Top

InitializeSupportedFilterOperators (UltraGrid, character)
Purpose: Initializes the supported filter operators
Notes: Values depend on the Column's data types

Parameters:
poGrid Infragistics.Win.UltraWinGrid.UltraGrid
The source grid
pcWordIndexColumns CHARACTER
Comma delimited list of grid columns that should support the contains operator
Top

Consultingwerk.OperatorEnum OperatorEnumFromOperator (character)
Purpose: Returns the UltraGrid FilterComparisionOperator matching the ABL filter
operator
Notes: Supported UltraGrid FilterOperators per data type (plUseOperators = TRUE):
LOGICAL: Equals, NotEquals
DATE, DATETIME, DATETIME-TZ, Equals, NotEquals, GreaterThan, GreaterThanOrEqualTo,
DECIMAL, INTEGER, INT64: LessThan, LessThanOrEqualTo
CHARACTER, LONGCHAR: Equals, NotEquals, StartsWith, Like, EndsWith,
GreaterThan, GreaterThanOrEqualTo, LessThan, LessThanOrEqualTo

Parameters:
pcOperatorString CHARACTER
The query operator string
Returns Consultingwerk.OperatorEnum
The resulting FilterComparisionOperator value
Top

Consultingwerk.OperatorEnum OperatorFromList (character, character)
Purpose: Returns the operator for the given column from the list
Notes:

Parameters:
pcOperators CHARACTER
Comma delimited list of field=operator pairs
pcColumn CHARACTER
The name of the column to return the operator for
Returns Consultingwerk.OperatorEnum
The OperatorEnum
Top

Consultingwerk.OperatorEnum OperatorFromUltraGrid (FilterComparisionOperator)
Purpose: Returns the OperatorEnum matching the UltraGridFilterCell FilterOperator
Notes: Supported UltraGrid FilterOperators per data type (plUseOperators = TRUE):
LOGICAL: Equals, NotEquals
DATE, DATETIME, DATETIME-TZ, Equals, NotEquals, GreaterThan, GreaterThanOrEqualTo,
DECIMAL, INTEGER, INT64: LessThan, LessThanOrEqualTo
CHARACTER, LONGCHAR: Equals, NotEquals, StartsWith, Like, EndsWith,
GreaterThan, GreaterThanOrEqualTo, LessThan, LessThanOrEqualTo
This method returns MATCHES for EndsWith. The BuildQueryExpression method
is required to convert the filter pattern from "abc" to "*abc"

Parameters:
poFilter Infragistics.Win.UltraWinGrid.FilterComparisionOperator
The FilterOperator of the UltraGridFilterCell
Returns Consultingwerk.OperatorEnum
The resulting OperatorEnum value


Constructor Detail
Top

UltraGridFilterRowHelper ()
Purpose: Disallow instance creation
Notes:



©2006-2026 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       10.10.2026 15:40:06