Namespace: Consultingwerk
Class 
QueryExpression Copy to Clipboard
Parent classes:
Progress.Lang.Object
Consultingwerk.JsonSerializable
Consultingwerk.QueryExpression

Inherits: Consultingwerk.JsonSerializable
Implements: Consultingwerk.IJsonSerializable, Consultingwerk.IQueryExpression, Consultingwerk.IQueryExpressionForWalker

File:QueryExpression
Author(s):Mike Fechner / Consultingwerk Ltd.
Created:Wed Oct 10 10:52:28 CEST 2012

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



Top Method Summary
Options Name Purpose
# AddSerializableProperties (character) Add a list of Serializable Properties to the SerializableProperties property
Inherited from Consultingwerk.JsonSerializable
+ Deserialize (longchar) Deserializes a LONGCHAR representation of the state of the class instance
Inherited from Consultingwerk.JsonSerializable
+ DeserializeFromJsonObject (JsonObject) Initializes the object instance based on the passed in JsonObject representation of the object instance
Inherited from Consultingwerk.JsonSerializable
# DeserializeProperty (JsonObject, character, character) Deserializes a single property value to the current JsonObject
Inherited from Consultingwerk.JsonSerializable
+ Consultingwerk.QueryExpression FindQueryExpressionForBufferField (BufferFieldName, IQueryExpression) Locates a QueryExpression with the given BufferFieldName as the first operand
+ CHARACTER GetExpression () Returns the Expression to be used in a Query String
+ Consultingwerk.QueryExpression GetExpressionForField (character, IQueryExpression) Returns the expression (QueryExpression) for the the given Buffer Field Name
+ Consultingwerk.ListQueryExpression GetExpressionsForField (character, character, IQueryExpression) Returns the list of expressions (QueryExpression) for the the given Buffer Field Name
+ Consultingwerk.ListQueryExpression GetExpressionsForField (character, IQueryExpression) Returns the list of expressions (QueryExpression) for the the given Buffer Field Name
+ CHARACTER GetSerializableProperties () Returns the meta data of the serializable properties
Inherited from Consultingwerk.JsonSerializable
+ LOGICAL HasExpressionForField (character, IQueryExpression) Returns if the given IQueryExpression (typically QueryExpression or ListQueryExpression) contains an expression for the given Buffer Field Name
+ CHARACTER SecondOperandAsCharacter () Returns the second Operand as a CHARACTER Value
+ LOGICAL SecondOperandAsLogical () Returns the second Operand as a LOGICAL Value
+ LONGCHAR Serialize () Returns a LONGCHAR representation of the state of the class instance
Inherited from Consultingwerk.JsonSerializable
# SerializeProperty (JsonObject, character, character) Serializes a single property value to the current JsonObject
Inherited from Consultingwerk.JsonSerializable
+ Progress.Json.ObjectModel.JsonObject ToJsonObject () Returns a JsonObject representation of the state of the class instance
Inherited from Consultingwerk.JsonSerializable
+ LOGICAL WalkQueryExpression (IQueryExpression, IQueryExpressionWalker) Recursively traverses ListQueryExpressions and calls back for every QueryExpression/CanDoQueryExpression etc. into the walker's method
+ LONGCHAR WriteJson () Returns a LONGCHAR representation of the state of the class instance
Inherited from Consultingwerk.JsonSerializable
+ LONGCHAR WriteXml () Returns an XML LONGCHAR representation of the object instance
Inherited from Consultingwerk.JsonSerializable
+ HANDLE XmlSerialize (handle) Serializes the properties of the current object instance to an existing X-NODEREF object
Inherited from Consultingwerk.JsonSerializable
+ XmlSerializeProperties (handle) Serializes the properties of this object instance as child nodes of the given node
Inherited from Consultingwerk.JsonSerializable
# XmlSerializeProperty (handle, character, character) Serializes a single property value to the current parent XmlNode
Inherited from Consultingwerk.JsonSerializable

Top Constructor Summary
Options Name Purpose
+ QueryExpression () Constructor for the QueryExpression class
+ QueryExpression (character, OperatorEnum, character) Constructor for the QueryExpression class
+ QueryExpression (character, OperatorEnum, date) Constructor for the QueryExpression class
+ QueryExpression (character, OperatorEnum, datetime) Constructor for the QueryExpression class
+ QueryExpression (character, OperatorEnum, datetime-tz) Constructor for the QueryExpression class
+ QueryExpression (character, OperatorEnum, decimal) Constructor for the QueryExpression class
+ QueryExpression (character, OperatorEnum, int64) Constructor for the QueryExpression class
+ QueryExpression (character, OperatorEnum, integer) Constructor for the QueryExpression class
+ QueryExpression (character, OperatorEnum, IQueryExpression) Constructor for the QueryExpression class
+ QueryExpression (character, OperatorEnum, logical) Constructor for the QueryExpression class
+ QueryExpression (character, OperatorEnum, rowid) Constructor for the QueryExpression class
+ QueryExpression (IQueryExpression, OperatorEnum, character) Constructor for the QueryExpression class
+ QueryExpression (IQueryExpression, OperatorEnum, date) Constructor for the QueryExpression class
+ QueryExpression (IQueryExpression, OperatorEnum, datetime) Constructor for the QueryExpression class
+ QueryExpression (IQueryExpression, OperatorEnum, datetime-tz) Constructor for the QueryExpression class
+ QueryExpression (IQueryExpression, OperatorEnum, decimal) Constructor for the QueryExpression class
+ QueryExpression (IQueryExpression, OperatorEnum, int64) Constructor for the QueryExpression class
+ QueryExpression (IQueryExpression, OperatorEnum, integer) Constructor for the QueryExpression class
+ QueryExpression (IQueryExpression, OperatorEnum, IQueryExpression) Constructor for the QueryExpression class
+ QueryExpression (IQueryExpression, OperatorEnum, logical) Constructor for the QueryExpression class
+ QueryExpression (IQueryExpression, OperatorEnum, rowid) Constructor for the QueryExpression class

Top Property Summary
Options Name Purpose
+ Consultingwerk.IQueryExpression FirstOperand
+ Consultingwerk.IJsonDateTypeFormatter JsonDateTypeFormatter
Inherited from Consultingwerk.JsonSerializable
+ Consultingwerk.OperatorEnum Operator
+ Consultingwerk.IQueryExpression SecondOperand
+ LOGICAL SerializeEmptyLists
Inherited from Consultingwerk.JsonSerializable
+ LOGICAL SerializeNullValues
Inherited from Consultingwerk.JsonSerializable
+ LOGICAL UseSerializedTypeInformation
Inherited from Consultingwerk.JsonSerializable


Method Detail
Top

PROTECTED AddSerializableProperties (character)
Inherited from Consultingwerk.JsonSerializable
Purpose: Add a list of Serializable Properties to the SerializableProperties property
Notes: Required as a workaround to full reflection only. We *may* remove this
method once Progress Software has implemented full reflection

Parameters:
pcSerializableProperties CHARACTER
A comma delimited list of serializable properties
Top

PUBLIC Deserialize (longchar)
Inherited from Consultingwerk.JsonSerializable
Purpose: Deserializes a LONGCHAR representation of the state of the class instance
Notes:

Parameters:
pcSerializedReprasentation LONGCHAR
The stored LONGCHAR representation of the objects data
Top

PUBLIC DeserializeFromJsonObject (JsonObject)
Inherited from Consultingwerk.JsonSerializable
Purpose: Initializes the object instance based on the passed in JsonObject
representation of the object instance
Notes:

Parameters:
poJsonObject JsonObject
The stored JsonObject representation of the objects data
Top

PROTECTED DeserializeProperty (JsonObject, character, character)
Inherited from Consultingwerk.JsonSerializable
Purpose: Deserializes a single property value to the current JsonObject
Notes: Allows to override the handling of individual properties during the
JsonSerialization
Notes:

Parameters:
poJsonObject JsonObject
The reference to the source JsonObject
pcProperty CHARACTER
The name of the property in the JsonObject
pcType CHARACTER
The type of the property
Top

PUBLIC Consultingwerk.QueryExpression FindQueryExpressionForBufferField (BufferFieldName, IQueryExpression)
Purpose: Locates a QueryExpression with the given BufferFieldName as the
first operand
Notes: Recursively traverses ListQueryExpressions

Parameters:
poField Consultingwerk.BufferFieldName
The BufferFieldName to locate
poExpression Consultingwerk.IQueryExpression
The IQueryExpression to look in for the BufferFieldName
Returns Consultingwerk.QueryExpression
The QueryExpression for the BufferFieldName
Top

PUBLIC CHARACTER GetExpression ()
Purpose: Returns the Expression to be used in a Query String
Notes:

Returns CHARACTER
The CHARACTER Expression
Top

PUBLIC Consultingwerk.QueryExpression GetExpressionForField (character, IQueryExpression)
Purpose: Returns the expression (QueryExpression) for the the given Buffer Field
Name
Notes: Based on FindQueryExpressionForBufferField (), returns invalid object
reference when the field is not contained

Parameters:
pcFieldName CHARACTER
The buffer field name to test
poExpression Consultingwerk.IQueryExpression
The IQueryExpression to look in for the BufferFieldName
Returns Consultingwerk.QueryExpression
The expression (QueryExpression) for the the given Buffer Field Name
Top

PUBLIC Consultingwerk.ListQueryExpression GetExpressionsForField (character, character, IQueryExpression)
Purpose: Returns the list of expressions (QueryExpression) for the the given
Buffer Field Name
Notes:

Parameters:
pcFieldName CHARACTER
The buffer field name to test
pcMapFieldName CHARACTER
The name of the field to use in the resulting list
poExpression Consultingwerk.IQueryExpression
The IQueryExpression to look in for the BufferFieldName
Returns Consultingwerk.ListQueryExpression
The expression (QueryExpression) for the the given Buffer Field Name
Top

PUBLIC Consultingwerk.ListQueryExpression GetExpressionsForField (character, IQueryExpression)
Purpose: Returns the list of expressions (QueryExpression) for the the given
Buffer Field Name
Notes:

Parameters:
pcFieldName CHARACTER
The buffer field name to test
poExpression Consultingwerk.IQueryExpression
The IQueryExpression to look in for the BufferFieldName
Returns Consultingwerk.ListQueryExpression
The expression (QueryExpression) for the the given Buffer Field Name
Top

PUBLIC CHARACTER GetSerializableProperties ()
Inherited from Consultingwerk.JsonSerializable
Purpose: Returns the meta data of the serializable properties
Notes:

Returns CHARACTER
The serializable properties meta data as a comma delimited list
Top

PUBLIC LOGICAL HasExpressionForField (character, IQueryExpression)
Purpose: Returns if the given IQueryExpression (typically QueryExpression or
ListQueryExpression) contains an expression for the given Buffer Field
Name
Notes: Based on FindQueryExpressionForBufferField ()

Parameters:
pcFieldName CHARACTER
The buffer field name to test
poExpression Consultingwerk.IQueryExpression
The IQueryExpression to look in for the BufferFieldName
Returns LOGICAL
Logical value indicating if the IQueryExpression contains an expression for the given Buffer Field
Top

PUBLIC CHARACTER SecondOperandAsCharacter ()
Purpose: Returns the second Operand as a CHARACTER Value
Notes: Returns ? when the value is not convertable

Returns CHARACTER
The SecondOperand as a CHARACTER Value
Top

PUBLIC LOGICAL SecondOperandAsLogical ()
Purpose: Returns the second Operand as a LOGICAL Value
Notes: Returns ? when the value is not convertable

Returns LOGICAL
The SecondOperand as a LOGICAL Value
Top

PUBLIC LONGCHAR Serialize ()
Inherited from Consultingwerk.JsonSerializable
Purpose: Returns a LONGCHAR representation of the state of the class instance
Notes: Returns the classname together with the Json serialization

Returns LONGCHAR
The LONGCHAR representation of the ISerializable objects data
Top

PROTECTED SerializeProperty (JsonObject, character, character)
Inherited from Consultingwerk.JsonSerializable
Purpose: Serializes a single property value to the current JsonObject
Notes: Allows to override the handling of individual properties during the
JsonSerialization

Parameters:
poJsonObject JsonObject
The reference to the target JsonObject
pcProperty CHARACTER
The name of the property in the JsonObject
pcType CHARACTER
The type of the property
Top

PUBLIC Progress.Json.ObjectModel.JsonObject ToJsonObject ()
Inherited from Consultingwerk.JsonSerializable
Purpose: Returns a JsonObject representation of the state of the class instance
Notes: Returns the classname together with the Json serialization of the
object

Returns Progress.Json.ObjectModel.JsonObject
The Progress.Json.ObjectModel.JsonObject representation of the ISerializable objects data
Top

PUBLIC LOGICAL WalkQueryExpression (IQueryExpression, IQueryExpressionWalker)
Purpose: Recursively traverses ListQueryExpressions and calls back for every
QueryExpression/CanDoQueryExpression etc. into the walker's method
Notes:

Parameters:
poExpression Consultingwerk.IQueryExpression
The IQueryExpression to look in for the BufferFieldName
poWalker Consultingwerk.IQueryExpressionWalker
The IQueryExpressionWalker instance
Returns LOGICAL
Logical value indicating if the process was cancelled (TRUE = cancel)
Top

PUBLIC LONGCHAR WriteJson ()
Inherited from Consultingwerk.JsonSerializable
Purpose: Returns a LONGCHAR representation of the state of the class instance
Notes: Returns the classname together with the Json serialization
This method is a facade to the JsonSerializable:Serialize method

Returns LONGCHAR
The LONGCHAR representation of the ISerializable objects data
Top

PUBLIC LONGCHAR WriteXml ()
Inherited from Consultingwerk.JsonSerializable
Purpose: Returns an XML LONGCHAR representation of the object instance
Notes:

Returns LONGCHAR
The LONGCHAR representation of the ISerializable objects data
Top

PUBLIC HANDLE XmlSerialize (handle)
Inherited from Consultingwerk.JsonSerializable
Purpose: Serializes the properties of the current object instance to
an existing X-NODEREF object
Notes:

Parameters:
phParent HANDLE
The reference to the parent XML Node or Document
Returns HANDLE
The X-NODEREF with the properties of the serialized object
Top

PUBLIC XmlSerializeProperties (handle)
Inherited from Consultingwerk.JsonSerializable
Purpose: Serializes the properties of this object instance as child nodes of
the given node
Notes:

Parameters:
phObjectNode HANDLE
The reference to the X-NODEREF object that represents the node for the current instance
Top

PROTECTED XmlSerializeProperty (handle, character, character)
Inherited from Consultingwerk.JsonSerializable
Purpose: Serializes a single property value to the current parent XmlNode
Notes: Allows to override the handling of individual properties during the
XmlSerialization

Parameters:
phParentNode HANDLE
The reference to the parent XML Node
pcProperty CHARACTER
The name of the property in the JsonObject
pcType CHARACTER
The type of the property


Constructor Detail
Top

PUBLIC QueryExpression ()
Purpose: Constructor for the QueryExpression class
Notes:

Top

PUBLIC QueryExpression (character, OperatorEnum, character)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
pcFieldName CHARACTER
The name of the Field to Filter on
poOperator Consultingwerk.OperatorEnum
The operator
pcExpression CHARACTER
A Character Expression to as the argument
Top

PUBLIC QueryExpression (character, OperatorEnum, date)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
pcFieldName CHARACTER
The name of the Field to Filter on
poOperator Consultingwerk.OperatorEnum
The operator
pdtExpression DATE
A Date Expression to as the argument
Top

PUBLIC QueryExpression (character, OperatorEnum, datetime)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
pcFieldName CHARACTER
The name of the Field to Filter on
poOperator Consultingwerk.OperatorEnum
The operator
pdtExpression DATETIME
A DateTime Expression to as the argument
Top

PUBLIC QueryExpression (character, OperatorEnum, datetime-tz)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
pcFieldName CHARACTER
The name of the Field to Filter on
poOperator Consultingwerk.OperatorEnum
The operator
pdtExpression DATETIME-TZ
A DateTime Expression to as the argument
Top

PUBLIC QueryExpression (character, OperatorEnum, decimal)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
pcFieldName CHARACTER
The name of the Field to Filter on
poOperator Consultingwerk.OperatorEnum
The operator
pdeExpression DECIMAL
A Decimal Expression to as the argument
Top

PUBLIC QueryExpression (character, OperatorEnum, int64)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
pcFieldName CHARACTER
The name of the Field to Filter on
poOperator Consultingwerk.OperatorEnum
The operator
piExpression INT64
An Int64 Expression to as the argument
Top

PUBLIC QueryExpression (character, OperatorEnum, integer)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
pcFieldName CHARACTER
The name of the Field to Filter on
poOperator Consultingwerk.OperatorEnum
The operator
piExpression INTEGER
An Integer Expression to as the argument
Top

PUBLIC QueryExpression (character, OperatorEnum, IQueryExpression)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
pcFieldName CHARACTER
The name of the Field to Filter on
poOperator Consultingwerk.OperatorEnum
The operator
poSecondExpression Consultingwerk.IQueryExpression
The right operand of the Query Expression
Top

PUBLIC QueryExpression (character, OperatorEnum, logical)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
pcFieldName CHARACTER
The name of the Field to Filter on
poOperator Consultingwerk.OperatorEnum
The operator
plExpression LOGICAL
A Logical Expression to as the argument
Top

PUBLIC QueryExpression (character, OperatorEnum, rowid)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
pcFieldName CHARACTER
The name of the Field to Filter on
poOperator Consultingwerk.OperatorEnum
The operator
proExpression ROWID
A Rowid Expression to as the argument
Top

PUBLIC QueryExpression (IQueryExpression, OperatorEnum, character)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
poFirstExpression Consultingwerk.IQueryExpression
The left operand of the Query Expression
poOperator Consultingwerk.OperatorEnum
The operator
pcExpression CHARACTER
A Character Expression to as the argument
Top

PUBLIC QueryExpression (IQueryExpression, OperatorEnum, date)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
poFirstExpression Consultingwerk.IQueryExpression
The left operand of the Query Expression
poOperator Consultingwerk.OperatorEnum
The operator
pdtExpression DATE
A Date Expression to as the argument
Top

PUBLIC QueryExpression (IQueryExpression, OperatorEnum, datetime)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
poFirstExpression Consultingwerk.IQueryExpression
The left operand of the Query Expression
poOperator Consultingwerk.OperatorEnum
The operator
pdtExpression DATETIME
A DateTime Expression to as the argument
Top

PUBLIC QueryExpression (IQueryExpression, OperatorEnum, datetime-tz)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
poFirstExpression Consultingwerk.IQueryExpression
The left operand of the Query Expression
poOperator Consultingwerk.OperatorEnum
The operator
pdtExpression DATETIME-TZ
A DateTime Expression to as the argument
Top

PUBLIC QueryExpression (IQueryExpression, OperatorEnum, decimal)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
poFirstExpression Consultingwerk.IQueryExpression
The left operand of the Query Expression
poOperator Consultingwerk.OperatorEnum
The operator
pdeExpression DECIMAL
A Decimal Expression to as the argument
Top

PUBLIC QueryExpression (IQueryExpression, OperatorEnum, int64)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
poFirstExpression Consultingwerk.IQueryExpression
The left operand of the Query Expression
poOperator Consultingwerk.OperatorEnum
The operator
piExpression INT64
An Int64 Expression to as the argument
Top

PUBLIC QueryExpression (IQueryExpression, OperatorEnum, integer)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
poFirstExpression Consultingwerk.IQueryExpression
The left operand of the Query Expression
poOperator Consultingwerk.OperatorEnum
The operator
piExpression INTEGER
An Integer Expression to as the argument
Top

PUBLIC QueryExpression (IQueryExpression, OperatorEnum, IQueryExpression)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
poFirstExpression Consultingwerk.IQueryExpression
The left operand of the Query Expression
poOperator Consultingwerk.OperatorEnum
The operator
poSecondExpression Consultingwerk.IQueryExpression
The right operand of the Query Expression
Top

PUBLIC QueryExpression (IQueryExpression, OperatorEnum, logical)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
poFirstExpression Consultingwerk.IQueryExpression
The left operand of the Query Expression
poOperator Consultingwerk.OperatorEnum
The operator
plExpression LOGICAL
A Logical Expression to as the argument
Top

PUBLIC QueryExpression (IQueryExpression, OperatorEnum, rowid)
Purpose: Constructor for the QueryExpression class
Notes:

Parameters:
poFirstExpression Consultingwerk.IQueryExpression
The left operand of the Query Expression
poOperator Consultingwerk.OperatorEnum
The operator
proExpression ROWID
A Rowid Expression to as the argument


Property Detail
Top

PUBLIC Consultingwerk.IQueryExpression FirstOperand

Returns Consultingwerk.IQueryExpression
Top

PUBLIC Consultingwerk.IJsonDateTypeFormatter JsonDateTypeFormatter
Inherited from Consultingwerk.JsonSerializable

Returns Consultingwerk.IJsonDateTypeFormatter
Top

PUBLIC Consultingwerk.OperatorEnum Operator

Returns Consultingwerk.OperatorEnum
Top

PUBLIC Consultingwerk.IQueryExpression SecondOperand

Returns Consultingwerk.IQueryExpression
Top

PUBLIC LOGICAL SerializeEmptyLists
Inherited from Consultingwerk.JsonSerializable

Returns LOGICAL
Top

PUBLIC LOGICAL SerializeNullValues
Inherited from Consultingwerk.JsonSerializable

Returns LOGICAL
Top

PUBLIC LOGICAL UseSerializedTypeInformation
Inherited from Consultingwerk.JsonSerializable

Returns LOGICAL


©2006-2020 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       04.02.2020 23:14:08