/ doc / tocInheritance / QueryExpression / 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

Edit single sub keys only: __TOCDet

Generated 2025-07-05 03:15:06.375 UTC