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
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
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

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

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       13.04.2026 10:33:36