/ doc / toc / ARCQuery / Class / QueryExpressionPivot

QueryExpressionPivot

Edit keys at this level only

Edit keys at all sub levels.
NOTE: Edits are always additive. Use 'Invalid' in order to delete keys.

__TOCDet/Assembly = ARCQuery
__TOCDet/Description = Creates a table by querying over two keys like0x000D0x000A  For 'Order', 'PIVOT Product BY Year'.0x000D0x000Aor0x000D0x000A  'PIVOT Product BY Year SUM Amount'.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.0x000D0x000A0x000D0x000ASee also:0x000D0x000A-QueryExpressionAggregate- which aggregates over only one key0x000D0x000Aand0x000D0x000A-FunctionKeyAggregate- which operates over a collection of properties.0x000D0x000A0x000D0x000ATODO: Nov 2020: There is lot of similar code in -QueryExpressionPivot- and -QueryExpressionAggregate.0x000D0x000A
__TOCDet/DocFragType = Class
__TOCDet/Name = QueryExpressionPivot
__TOCDet/Namespace = ARCQuery
__TOCDet/Type = QueryExpressionPivot
__TOCDet/Attribute/AssemblyName = ARCQuery
__TOCDet/Attribute/BaseTypes = QueryExpression
__TOCDet/Attribute/ClassNamespace = ARCQuery
__TOCDet/Attribute/ClassType = QueryExpressionPivot
__TOCDet/Attribute/Description = Creates a table by querying over two keys like0x000D0x000A  For 'Order', 'PIVOT Product BY Year'.0x000D0x000Aor0x000D0x000A  'PIVOT Product BY Year SUM Amount'.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.0x000D0x000A0x000D0x000ASee also:0x000D0x000A-QueryExpressionAggregate- which aggregates over only one key0x000D0x000Aand0x000D0x000A-FunctionKeyAggregate- which operates over a collection of properties.0x000D0x000A0x000D0x000ATODO: Nov 2020: There is lot of similar code in -QueryExpressionPivot- and -QueryExpressionAggregate.0x000D0x000A
__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CQueryExpression0xoooo003E
AggregationKey/__TOCDet/Assembly = ARCQuery
AggregationKey/__TOCDet/Description = This is often null (with -AggregationType- correspondingly set to Count-).0x000D0x000AIteration then looks like0x000D0x000A  'PIVOT Product BY Year'.0x000D0x000AIf not null then iteration looks like:0x000D0x000A  'PIVOT Product BY Year SUM Amount'
AggregationKey/__TOCDet/DocFragType = ClassMember
AggregationKey/__TOCDet/IsInherited = False
AggregationKey/__TOCDet/IsInheritedDoc = False
AggregationKey/__TOCDet/Lines = 5
AggregationKey/__TOCDet/Name = AggregationKey
AggregationKey/__TOCDet/Namespace = ARCQuery
AggregationKey/__TOCDet/Type = QueryExpressionPivot
AggregationKey/__TOCDet/Attribute/DeclaringType = QueryExpressionPivot
AggregationKey/__TOCDet/Attribute/Description = This is often null (with -AggregationType- correspondingly set to Count-).0x000D0x000AIteration then looks like0x000D0x000A  'PIVOT Product BY Year'.0x000D0x000AIf not null then iteration looks like:0x000D0x000A  'PIVOT Product BY Year SUM Amount'
AggregationKey/__TOCDet/Attribute/MethodName = AggregationKey
AggregationKey/__TOCDet/Attribute/MethodSignature = ARCCore.IK AggregationKey
AggregationType/__TOCDet/Assembly = ARCQuery
AggregationType/__TOCDet/Description = Most common value is -Count-, in which case -AggregationKey- may be correspondingly set to null.
AggregationType/__TOCDet/DocFragType = ClassMember
AggregationType/__TOCDet/IsInherited = False
AggregationType/__TOCDet/IsInheritedDoc = False
AggregationType/__TOCDet/Lines = 1
AggregationType/__TOCDet/Name = AggregationType
AggregationType/__TOCDet/Namespace = ARCQuery
AggregationType/__TOCDet/Type = QueryExpressionPivot
AggregationType/__TOCDet/Attribute/DeclaringType = QueryExpressionPivot
AggregationType/__TOCDet/Attribute/Description = Most common value is -Count-, in which case -AggregationKey- may be correspondingly set to null.
AggregationType/__TOCDet/Attribute/MethodName = AggregationType
AggregationType/__TOCDet/Attribute/MethodSignature = ARCQuery.AggregationType AggregationType
Execute/__TOCDet/Assembly = ARCQuery
Execute/__TOCDet/Description = Transforms the given input collection into a resulting collection.0x000D0x000A0x000D0x000AThe parameter data storage is used for sub classes implementing relations (transforming to collections of other types).0x000D0x000A0x000D0x000ATODO: Most probably we also need a parameter for what entity type the input collection represents TODO: (one might of course sample it, but the calling method should know anyway). 0x000D0x000ATODO: It is possible also that we need a parameter for current LinkContext, or OR TODO: rather, let parameter DataStorage just be the same where we find the key of the current entity type TODO: and assume that other entity collections are stored at the same level.0x000D0x000ATODO:0x000D0x000ATODO: SOLUTION: QueryCollection-class with all necessary parameters. This also enables0x000D0x000ATODO: method chaining (fluent interface) AND logging AND timing AND exception handling AND so on AND so on.0x000D0x000ATODO:0x000D0x000ATODO: Each Query-implementation adds an Extension method against QueryCollection.0x000D0x000ATODO: QueryCollection itself is IP, with keys for log-data and a Result-key.
Execute/__TOCDet/DocFragType = ClassMember
Execute/__TOCDet/IsInherited = False
Execute/__TOCDet/IsInheritedDoc = True
Execute/__TOCDet/Name = Execute
Execute/__TOCDet/Namespace = ARCQuery
Execute/__TOCDet/Type = QueryExpressionPivot
Execute/__TOCDet/Attribute/DeclaringType = QueryExpression
Execute/__TOCDet/Attribute/Description = Transforms the given input collection into a resulting collection.0x000D0x000A0x000D0x000AThe parameter data storage is used for sub classes implementing relations (transforming to collections of other types).0x000D0x000A0x000D0x000ATODO: Most probably we also need a parameter for what entity type the input collection represents TODO: (one might of course sample it, but the calling method should know anyway). 0x000D0x000ATODO: It is possible also that we need a parameter for current LinkContext, or OR TODO: rather, let parameter DataStorage just be the same where we find the key of the current entity type TODO: and assume that other entity collections are stored at the same level.0x000D0x000ATODO:0x000D0x000ATODO: SOLUTION: QueryCollection-class with all necessary parameters. This also enables0x000D0x000ATODO: method chaining (fluent interface) AND logging AND timing AND exception handling AND so on AND so on.0x000D0x000ATODO:0x000D0x000ATODO: Each Query-implementation adds an Extension method against QueryCollection.0x000D0x000ATODO: QueryCollection itself is IP, with keys for log-data and a Result-key.
Execute/__TOCDet/Attribute/MethodName = Execute
Execute/__TOCDet/Attribute/MethodSignature = ARCQuery.QueryExpressionWithSuggestions Execute(ARCQuery.Query)
GetCrossSummationChecker/__TOCDet/Assembly = ARCQuery
GetCrossSummationChecker/__TOCDet/Description = Returns a cross sum checker for int, long, double, Timespan.0x000D0x000A0x000D0x000AThrows an exception for other types.0x000D0x000A0x000D0x000AThe cross checker throws an exeption if the two sums given are not equal, or (in the case of floating point values) differ too much.0x000D0x000A(The floating point checks are performed with a huge margin since we are more interesting in catching blatant coding errors, not dwelving into the finer points of floating point maths.)
GetCrossSummationChecker/__TOCDet/DocFragType = ClassMember
GetCrossSummationChecker/__TOCDet/IsInherited = False
GetCrossSummationChecker/__TOCDet/IsInheritedDoc = False
GetCrossSummationChecker/__TOCDet/Lines = 6
GetCrossSummationChecker/__TOCDet/Name = GetCrossSummationChecker
GetCrossSummationChecker/__TOCDet/Namespace = ARCQuery
GetCrossSummationChecker/__TOCDet/Type = QueryExpressionPivot
GetCrossSummationChecker/__TOCDet/Attribute/DeclaringType = QueryExpressionPivot
GetCrossSummationChecker/__TOCDet/Attribute/Description = Returns a cross sum checker for int, long, double, Timespan.0x000D0x000A0x000D0x000AThrows an exception for other types.0x000D0x000A0x000D0x000AThe cross checker throws an exeption if the two sums given are not equal, or (in the case of floating point values) differ too much.0x000D0x000A(The floating point checks are performed with a huge margin since we are more interesting in catching blatant coding errors, not dwelving into the finer points of floating point maths.)
GetCrossSummationChecker/__TOCDet/Attribute/MethodName = GetCrossSummationChecker
GetCrossSummationChecker/__TOCDet/Attribute/MethodSignature = System.Action0x006020x005BT,T0x005D GetCrossSummationChecker0x005BT0x005D()
SyntaxHelp/__TOCDet/Assembly = ARCQuery
SyntaxHelp/__TOCDet/Description = 1) 'PIVOT 0x007BrowKey0x007D BY 0x007BcolumnKey0x007D' like "PIVOT Colour BY Production.Year"0x000D0x000Aor0x000D0x000A2) 'PIVOT 0x007BrowKey0x007D BY 0x007BcolumnKey0x007D 0x007BaggregationType0x007D 0x007BaggregationKey0x007D' like "PIVOT Colour BY Production.Year SUM Price"
SyntaxHelp/__TOCDet/DocFragType = ClassMember
SyntaxHelp/__TOCDet/IsInherited = False
SyntaxHelp/__TOCDet/IsInheritedDoc = False
SyntaxHelp/__TOCDet/Lines = 3
SyntaxHelp/__TOCDet/Name = SyntaxHelp
SyntaxHelp/__TOCDet/Namespace = ARCQuery
SyntaxHelp/__TOCDet/Type = QueryExpressionPivot
SyntaxHelp/__TOCDet/Attribute/DeclaringType = QueryExpressionPivot
SyntaxHelp/__TOCDet/Attribute/Description = 1) 'PIVOT 0x007BrowKey0x007D BY 0x007BcolumnKey0x007D' like "PIVOT Colour BY Production.Year"0x000D0x000Aor0x000D0x000A2) 'PIVOT 0x007BrowKey0x007D BY 0x007BcolumnKey0x007D 0x007BaggregationType0x007D 0x007BaggregationKey0x007D' like "PIVOT Colour BY Production.Year SUM Price"
SyntaxHelp/__TOCDet/Attribute/MethodName = SyntaxHelp
SyntaxHelp/__TOCDet/Attribute/MethodSignature = System.String SyntaxHelp
TryCheckForExistenceOfKey/__TOCDet/Assembly = ARCQuery
TryCheckForExistenceOfKey/__TOCDet/Description = Used by query expressions in order to catch wrong field names used or misspelling of field names.0x000D0x000A0x000D0x000AReturns TRUE if either:0x000D0x000A1) -TryGetFromTypeAndFieldName succeeds (in which case out parameter keyAsPK will be set),0x000D0x000A2) (new from Jan 2022) -AllEntityMethodKeysForEntityTypeDict contains the key,0x000D0x000A3) -CurrentStrictness- = OFF,0x000D0x000A4) -Result- is empty, or,0x000D0x000A5) At least one element in -Result- contains the given key0x000D0x000A0x000D0x000ANote that this check must be deferred to the actual execution of the query, not at -TryParse-, because the query expression mechanism has no concept of for which entity types it operates on.0x000D0x000A0x000D0x000AWill call -ShouldTerminate- if fails to get the key, this again will set -TerminateReason- with detailed information about available keys (that is, with a helpful error message).
TryCheckForExistenceOfKey/__TOCDet/DocFragType = ClassMember
TryCheckForExistenceOfKey/__TOCDet/IsInherited = True
TryCheckForExistenceOfKey/__TOCDet/IsInheritedDoc = True
TryCheckForExistenceOfKey/__TOCDet/Name = TryCheckForExistenceOfKey
TryCheckForExistenceOfKey/__TOCDet/Namespace = ARCQuery
TryCheckForExistenceOfKey/__TOCDet/Type = QueryExpressionPivot
TryCheckForExistenceOfKey/__TOCDet/Attribute/DeclaringType = QueryExpression
TryCheckForExistenceOfKey/__TOCDet/Attribute/Description = Used by query expressions in order to catch wrong field names used or misspelling of field names.0x000D0x000A0x000D0x000AReturns TRUE if either:0x000D0x000A1) -TryGetFromTypeAndFieldName succeeds (in which case out parameter keyAsPK will be set),0x000D0x000A2) (new from Jan 2022) -AllEntityMethodKeysForEntityTypeDict contains the key,0x000D0x000A3) -CurrentStrictness- = OFF,0x000D0x000A4) -Result- is empty, or,0x000D0x000A5) At least one element in -Result- contains the given key0x000D0x000A0x000D0x000ANote that this check must be deferred to the actual execution of the query, not at -TryParse-, because the query expression mechanism has no concept of for which entity types it operates on.0x000D0x000A0x000D0x000AWill call -ShouldTerminate- if fails to get the key, this again will set -TerminateReason- with detailed information about available keys (that is, with a helpful error message).
TryCheckForExistenceOfKey/__TOCDet/Attribute/MethodName = TryCheckForExistenceOfKey
TryCheckForExistenceOfKey/__TOCDet/Attribute/MethodSignature = Boolean TryCheckForExistenceOfKey(ARCQuery.Query, ARCCore.IK, ARCCore.PK ByRef)

Edit single sub keys only: __TOCDet / AggregationKey / AggregationType / Execute / GetCrossSummationChecker / SyntaxHelp / TryCheckForExistenceOfKey

Generated 2025-04-07 11:59:25.385 UTC