FunctionKey

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 = Extracts data from an already existing value like extracting Year from a DateTime in 'Created.Year()'.0x000D0x000A0x000D0x000AThis is an expandable concept, that is, you can create your own implementations of this class in your -ApplicationSpecificCode-.0x000D0x000A0x000D0x000AOften the extraction is actually a simplification of the existing value, like Created.Year() which would for '2020-06-11 13:36' return '2020'.0x000D0x000A0x000D0x000AImplementing classes in -StandardAgoRapideCode-, more specific -ARCQuery-, are:0x000D0x000A-FunctionKeyDate-0x000D0x000A-FunctionKeyDayOfWeek-0x000D0x000A-FunctionKeyDouble-0x000D0x000A-FunctionKeyFirstLine-0x000D0x000A-FunctionKeyHourMinute-0x000D0x000A-FunctionKeyInt-0x000D0x000A-FunctionKeyLength-0x000D0x000A-FunctionKeyMonth-0x000D0x000A-FunctionKeyQuarter-0x000D0x000A-FunctionKeyTMB-0x000D0x000A-FunctionKeyTotalHours-0x000D0x000A-FunctionKeyTotalMinutes-0x000D0x000A-FunctionKeyType-0x000D0x000A-FunctionKeyWeek-0x000D0x000A-FunctionKeyYear-0x000D0x000A-FunctionKeyYearMonth-0x000D0x000A-FunctionKeyYearQuarter-0x000D0x000A-FunctionKeyYearWeek-0x000D0x000A(these are stored in -CompoundKey- as -FunctionKeys-.)0x000D0x000A0x000D0x000Aand also (see -FunctionKeyAggregate-):0x000D0x000A-FunctionKeyAggregateAvg-0x000D0x000A-FunctionKeyAggregateCount-0x000D0x000A-FunctionKeyAggregateDistinct-0x000D0x000A-FunctionKeyAggregateJoin-0x000D0x000A-FunctionKeyAggregateMax-0x000D0x000A-FunctionKeyAggregateMin-0x000D0x000A-FunctionKeyAggregateSum-0x000D0x000A(these are stored in -ForeignKey- as -AggregateKeys-.)0x000D0x000A0x000D0x000ATODO: Add a -PK- field, describing the value that is returned.0x000D0x000A0x000D0x000AIt can also be said to work as a function against a value field, but with the syntax 'value.functionName()' instead of functionName(value).0x000D0x000A0x000D0x000A(See also -ValueComparer- which can evaluate expressions like 'WHERE Created = ThisYear')0x000D0x000A0x000D0x000AExplanation of the conceptual difference between -ValueComparer- and -FunctionKey-:0x000D0x000AThese two concepts are working from two different 'origins'.0x000D0x000A-FunctionKey- is necessary if you want to pivot around the value (for instance with -QueryExpressionPivot-).0x000D0x000A-ValueComparer- is more practical if the value can have different interpretations at the same time.0x000D0x000AAn example is -ValueComparerDateTime- which understands that 'Created' can be all of 'ThisYear', 'ThisMonth', 'ThisWeek', 'InTheMorning', 'ThisMorning' and so on.0x000D0x000A(It would be time consuming to write all the necessary -FunctionKey- implementations in order to support this. and the query syntax would be more verbose ('Created.YearNumber = ThisYear' or something similar, instead of just 'Created = ThisYear').)0x000D0x000A0x000D0x000ANote that the concept is inherently expandable, you can create your own sub-classes and integrate them with -StandardAgoRapideCode-.0x000D0x000A0x000D0x000ANote how any -ApplicationSpecificCode- implementations must be added to -Parsers- at application startup in order for them to be recognized by -TryParse-.
__TOCDet/DocFragType = Class
__TOCDet/Name = FunctionKey
__TOCDet/Namespace = ARCQuery
__TOCDet/Type = FunctionKey
__TOCDet/Attribute/AssemblyName = ARCQuery
__TOCDet/Attribute/ClassNamespace = ARCQuery
__TOCDet/Attribute/ClassType = FunctionKey
__TOCDet/Attribute/Description = Extracts data from an already existing value like extracting Year from a DateTime in 'Created.Year()'.0x000D0x000A0x000D0x000AThis is an expandable concept, that is, you can create your own implementations of this class in your -ApplicationSpecificCode-.0x000D0x000A0x000D0x000AOften the extraction is actually a simplification of the existing value, like Created.Year() which would for '2020-06-11 13:36' return '2020'.0x000D0x000A0x000D0x000AImplementing classes in -StandardAgoRapideCode-, more specific -ARCQuery-, are:0x000D0x000A-FunctionKeyDate-0x000D0x000A-FunctionKeyDayOfWeek-0x000D0x000A-FunctionKeyDouble-0x000D0x000A-FunctionKeyFirstLine-0x000D0x000A-FunctionKeyHourMinute-0x000D0x000A-FunctionKeyInt-0x000D0x000A-FunctionKeyLength-0x000D0x000A-FunctionKeyMonth-0x000D0x000A-FunctionKeyQuarter-0x000D0x000A-FunctionKeyTMB-0x000D0x000A-FunctionKeyTotalHours-0x000D0x000A-FunctionKeyTotalMinutes-0x000D0x000A-FunctionKeyType-0x000D0x000A-FunctionKeyWeek-0x000D0x000A-FunctionKeyYear-0x000D0x000A-FunctionKeyYearMonth-0x000D0x000A-FunctionKeyYearQuarter-0x000D0x000A-FunctionKeyYearWeek-0x000D0x000A(these are stored in -CompoundKey- as -FunctionKeys-.)0x000D0x000A0x000D0x000Aand also (see -FunctionKeyAggregate-):0x000D0x000A-FunctionKeyAggregateAvg-0x000D0x000A-FunctionKeyAggregateCount-0x000D0x000A-FunctionKeyAggregateDistinct-0x000D0x000A-FunctionKeyAggregateJoin-0x000D0x000A-FunctionKeyAggregateMax-0x000D0x000A-FunctionKeyAggregateMin-0x000D0x000A-FunctionKeyAggregateSum-0x000D0x000A(these are stored in -ForeignKey- as -AggregateKeys-.)0x000D0x000A0x000D0x000ATODO: Add a -PK- field, describing the value that is returned.0x000D0x000A0x000D0x000AIt can also be said to work as a function against a value field, but with the syntax 'value.functionName()' instead of functionName(value).0x000D0x000A0x000D0x000A(See also -ValueComparer- which can evaluate expressions like 'WHERE Created = ThisYear')0x000D0x000A0x000D0x000AExplanation of the conceptual difference between -ValueComparer- and -FunctionKey-:0x000D0x000AThese two concepts are working from two different 'origins'.0x000D0x000A-FunctionKey- is necessary if you want to pivot around the value (for instance with -QueryExpressionPivot-).0x000D0x000A-ValueComparer- is more practical if the value can have different interpretations at the same time.0x000D0x000AAn example is -ValueComparerDateTime- which understands that 'Created' can be all of 'ThisYear', 'ThisMonth', 'ThisWeek', 'InTheMorning', 'ThisMorning' and so on.0x000D0x000A(It would be time consuming to write all the necessary -FunctionKey- implementations in order to support this. and the query syntax would be more verbose ('Created.YearNumber = ThisYear' or something similar, instead of just 'Created = ThisYear').)0x000D0x000A0x000D0x000ANote that the concept is inherently expandable, you can create your own sub-classes and integrate them with -StandardAgoRapideCode-.0x000D0x000A0x000D0x000ANote how any -ApplicationSpecificCode- implementations must be added to -Parsers- at application startup in order for them to be recognized by -TryParse-.
__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
__TOCDet/Attribute/InterfacesDirectlyImplemented = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
__TOCDet/Attribute/SubTypes = FunctionKeyAggregate0x003BFunctionKeyAggregateAvg0x003BFunctionKeyAggregateCount0x003BFunctionKeyAggregateDistinct0x003BFunctionKeyAggregateJoin0x003BFunctionKeyAggregateMax0x003BFunctionKeyAggregateMin0x003BFunctionKeyAggregateSum0x003BFunctionKeyDate0x003BFunctionKeyDayOfWeek0x003BFunctionKeyDouble0x003BFunctionKeyFirstLine0x003BFunctionKeyHourMinute0x003BFunctionKeyInt0x003BFunctionKeyLength0x003BFunctionKeyMonth0x003BFunctionKeyQuarter0x003BFunctionKeyTMB0x003BFunctionKeyTotalHours0x003BFunctionKeyTotalMinutes0x003BFunctionKeyType0x003BFunctionKeyWeek0x003BFunctionKeyYear0x003BFunctionKeyYearMonth0x003BFunctionKeyYearQuarter0x003BFunctionKeyYearWeek
FunctionKeyAggregate/__TOCDet/Assembly = ARCQuery
FunctionKeyAggregate/__TOCDet/Description = Operates over a collection of properties.0x000D0x000A0x000D0x000ASpecially understood by -ForeignKey-.0x000D0x000A0x000D0x000A-TryGetP- is implicit understood to receive an instance of -IP- containing an IEnumerable0x003CIP0x003E-collection as value.0x000D0x000A0x000D0x000AImplementing classes in -StandardAgoRapideCode-, more specific -ARCQuery-, are:0x000D0x000A-FunctionKeyAggregateCount-0x000D0x000A-FunctionKeyAggregateSum-0x000D0x000A-FunctionKeyAggregateMin-0x000D0x000A-FunctionKeyAggregateMax-0x000D0x000A-FunctionKeyAggregateAvg-0x000D0x000A-FunctionKeyAggregateJoin-0x000D0x000A0x000D0x000AImplementing classes that returns PValue0x003CList0x003CIP0x003E0x003E are:0x000D0x000A-FunctionKeyAggregateDistinct-0x000D0x000AThese usually give meaning only if followed by an 'ordinary' implementation that returns a PValue containing a single value.0x000D0x000AThis is specially understood by -TryGetPInternal-.0x000D0x000AStored in -ForeignKey- as -AggregateKeys-.0x000D0x000A0x000D0x000ASee also:0x000D0x000A-QueryExpressionAggregate- which aggregates over a key0x000D0x000Aand0x000D0x000A-QueryExpressionPivot- which creates a table by querying over two keys.0x000D0x000A
FunctionKeyAggregate/__TOCDet/DocFragType = Class
FunctionKeyAggregate/__TOCDet/Name = FunctionKeyAggregate
FunctionKeyAggregate/__TOCDet/Namespace = ARCQuery
FunctionKeyAggregate/__TOCDet/Type = FunctionKeyAggregate
FunctionKeyAggregate/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyAggregate/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyAggregate/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyAggregate/__TOCDet/Attribute/ClassType = FunctionKeyAggregate
FunctionKeyAggregate/__TOCDet/Attribute/Description = Operates over a collection of properties.0x000D0x000A0x000D0x000ASpecially understood by -ForeignKey-.0x000D0x000A0x000D0x000A-TryGetP- is implicit understood to receive an instance of -IP- containing an IEnumerable0x003CIP0x003E-collection as value.0x000D0x000A0x000D0x000AImplementing classes in -StandardAgoRapideCode-, more specific -ARCQuery-, are:0x000D0x000A-FunctionKeyAggregateCount-0x000D0x000A-FunctionKeyAggregateSum-0x000D0x000A-FunctionKeyAggregateMin-0x000D0x000A-FunctionKeyAggregateMax-0x000D0x000A-FunctionKeyAggregateAvg-0x000D0x000A-FunctionKeyAggregateJoin-0x000D0x000A0x000D0x000AImplementing classes that returns PValue0x003CList0x003CIP0x003E0x003E are:0x000D0x000A-FunctionKeyAggregateDistinct-0x000D0x000AThese usually give meaning only if followed by an 'ordinary' implementation that returns a PValue containing a single value.0x000D0x000AThis is specially understood by -TryGetPInternal-.0x000D0x000AStored in -ForeignKey- as -AggregateKeys-.0x000D0x000A0x000D0x000ASee also:0x000D0x000A-QueryExpressionAggregate- which aggregates over a key0x000D0x000Aand0x000D0x000A-QueryExpressionPivot- which creates a table by querying over two keys.0x000D0x000A
FunctionKeyAggregate/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyAggregate/__TOCDet/Attribute/SubTypes = FunctionKeyAggregateAvg0x003BFunctionKeyAggregateCount0x003BFunctionKeyAggregateDistinct0x003BFunctionKeyAggregateJoin0x003BFunctionKeyAggregateMax0x003BFunctionKeyAggregateMin0x003BFunctionKeyAggregateSum
FunctionKeyAggregate/FunctionKeyAggregateAvg/__TOCDet/Assembly = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateAvg/__TOCDet/Description = Calculates the average of the given properties.0x000D0x000A0x000D0x000AAny property not convertible to type of double is regarded as 0.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyAggregate/FunctionKeyAggregateAvg/__TOCDet/DocFragType = Class
FunctionKeyAggregate/FunctionKeyAggregateAvg/__TOCDet/Name = FunctionKeyAggregateAvg
FunctionKeyAggregate/FunctionKeyAggregateAvg/__TOCDet/Namespace = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateAvg/__TOCDet/Type = FunctionKeyAggregateAvg
FunctionKeyAggregate/FunctionKeyAggregateAvg/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateAvg/__TOCDet/Attribute/BaseTypes = FunctionKey0x003BFunctionKeyAggregate
FunctionKeyAggregate/FunctionKeyAggregateAvg/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateAvg/__TOCDet/Attribute/ClassType = FunctionKeyAggregateAvg
FunctionKeyAggregate/FunctionKeyAggregateAvg/__TOCDet/Attribute/Description = Calculates the average of the given properties.0x000D0x000A0x000D0x000AAny property not convertible to type of double is regarded as 0.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyAggregate/FunctionKeyAggregateAvg/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyAggregate/FunctionKeyAggregateCount/__TOCDet/Assembly = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateCount/__TOCDet/Description = Counts the number of properties found.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyAggregate/FunctionKeyAggregateCount/__TOCDet/DocFragType = Class
FunctionKeyAggregate/FunctionKeyAggregateCount/__TOCDet/Name = FunctionKeyAggregateCount
FunctionKeyAggregate/FunctionKeyAggregateCount/__TOCDet/Namespace = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateCount/__TOCDet/Type = FunctionKeyAggregateCount
FunctionKeyAggregate/FunctionKeyAggregateCount/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateCount/__TOCDet/Attribute/BaseTypes = FunctionKey0x003BFunctionKeyAggregate
FunctionKeyAggregate/FunctionKeyAggregateCount/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateCount/__TOCDet/Attribute/ClassType = FunctionKeyAggregateCount
FunctionKeyAggregate/FunctionKeyAggregateCount/__TOCDet/Attribute/Description = Counts the number of properties found.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyAggregate/FunctionKeyAggregateCount/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyAggregate/FunctionKeyAggregateDistinct/__TOCDet/Assembly = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateDistinct/__TOCDet/Description = Returns a list of the distinct values of the given properties.0x000D0x000A0x000D0x000AAny property not of type -PValue- will be ignored.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyAggregate/FunctionKeyAggregateDistinct/__TOCDet/DocFragType = Class
FunctionKeyAggregate/FunctionKeyAggregateDistinct/__TOCDet/Name = FunctionKeyAggregateDistinct
FunctionKeyAggregate/FunctionKeyAggregateDistinct/__TOCDet/Namespace = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateDistinct/__TOCDet/Type = FunctionKeyAggregateDistinct
FunctionKeyAggregate/FunctionKeyAggregateDistinct/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateDistinct/__TOCDet/Attribute/BaseTypes = FunctionKey0x003BFunctionKeyAggregate
FunctionKeyAggregate/FunctionKeyAggregateDistinct/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateDistinct/__TOCDet/Attribute/ClassType = FunctionKeyAggregateDistinct
FunctionKeyAggregate/FunctionKeyAggregateDistinct/__TOCDet/Attribute/Description = Returns a list of the distinct values of the given properties.0x000D0x000A0x000D0x000AAny property not of type -PValue- will be ignored.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyAggregate/FunctionKeyAggregateDistinct/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyAggregate/FunctionKeyAggregateJoin/__TOCDet/Assembly = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateJoin/__TOCDet/Description = Joins the given list of properties into a single property.0x000D0x000A0x000D0x000AReturns a PValue0x003CList0x003Cstring0x003E0x003E, that is, does not actually join the values because that is not necessary.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyAggregate/FunctionKeyAggregateJoin/__TOCDet/DocFragType = Class
FunctionKeyAggregate/FunctionKeyAggregateJoin/__TOCDet/Name = FunctionKeyAggregateJoin
FunctionKeyAggregate/FunctionKeyAggregateJoin/__TOCDet/Namespace = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateJoin/__TOCDet/Type = FunctionKeyAggregateJoin
FunctionKeyAggregate/FunctionKeyAggregateJoin/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateJoin/__TOCDet/Attribute/BaseTypes = FunctionKey0x003BFunctionKeyAggregate
FunctionKeyAggregate/FunctionKeyAggregateJoin/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateJoin/__TOCDet/Attribute/ClassType = FunctionKeyAggregateJoin
FunctionKeyAggregate/FunctionKeyAggregateJoin/__TOCDet/Attribute/Description = Joins the given list of properties into a single property.0x000D0x000A0x000D0x000AReturns a PValue0x003CList0x003Cstring0x003E0x003E, that is, does not actually join the values because that is not necessary.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyAggregate/FunctionKeyAggregateJoin/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyAggregate/FunctionKeyAggregateMax/__TOCDet/Assembly = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateMax/__TOCDet/Description = Calculates the maximum value of the given properties.0x000D0x000A0x000D0x000AAny property not convertible to type of double is regarded as 0.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyAggregate/FunctionKeyAggregateMax/__TOCDet/DocFragType = Class
FunctionKeyAggregate/FunctionKeyAggregateMax/__TOCDet/Name = FunctionKeyAggregateMax
FunctionKeyAggregate/FunctionKeyAggregateMax/__TOCDet/Namespace = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateMax/__TOCDet/Type = FunctionKeyAggregateMax
FunctionKeyAggregate/FunctionKeyAggregateMax/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateMax/__TOCDet/Attribute/BaseTypes = FunctionKey0x003BFunctionKeyAggregate
FunctionKeyAggregate/FunctionKeyAggregateMax/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateMax/__TOCDet/Attribute/ClassType = FunctionKeyAggregateMax
FunctionKeyAggregate/FunctionKeyAggregateMax/__TOCDet/Attribute/Description = Calculates the maximum value of the given properties.0x000D0x000A0x000D0x000AAny property not convertible to type of double is regarded as 0.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyAggregate/FunctionKeyAggregateMax/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyAggregate/FunctionKeyAggregateMin/__TOCDet/Assembly = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateMin/__TOCDet/Description = Calculates the minimum value of the given properties.0x000D0x000A0x000D0x000AAny property not convertible to type of double is regarded as 0.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyAggregate/FunctionKeyAggregateMin/__TOCDet/DocFragType = Class
FunctionKeyAggregate/FunctionKeyAggregateMin/__TOCDet/Name = FunctionKeyAggregateMin
FunctionKeyAggregate/FunctionKeyAggregateMin/__TOCDet/Namespace = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateMin/__TOCDet/Type = FunctionKeyAggregateMin
FunctionKeyAggregate/FunctionKeyAggregateMin/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateMin/__TOCDet/Attribute/BaseTypes = FunctionKey0x003BFunctionKeyAggregate
FunctionKeyAggregate/FunctionKeyAggregateMin/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateMin/__TOCDet/Attribute/ClassType = FunctionKeyAggregateMin
FunctionKeyAggregate/FunctionKeyAggregateMin/__TOCDet/Attribute/Description = Calculates the minimum value of the given properties.0x000D0x000A0x000D0x000AAny property not convertible to type of double is regarded as 0.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyAggregate/FunctionKeyAggregateMin/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyAggregate/FunctionKeyAggregateSum/__TOCDet/Assembly = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateSum/__TOCDet/Description = Sums the given properties.0x000D0x000A0x000D0x000AAny property not convertible to type of double is ignored.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyAggregate/FunctionKeyAggregateSum/__TOCDet/DocFragType = Class
FunctionKeyAggregate/FunctionKeyAggregateSum/__TOCDet/Name = FunctionKeyAggregateSum
FunctionKeyAggregate/FunctionKeyAggregateSum/__TOCDet/Namespace = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateSum/__TOCDet/Type = FunctionKeyAggregateSum
FunctionKeyAggregate/FunctionKeyAggregateSum/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateSum/__TOCDet/Attribute/BaseTypes = FunctionKey0x003BFunctionKeyAggregate
FunctionKeyAggregate/FunctionKeyAggregateSum/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyAggregate/FunctionKeyAggregateSum/__TOCDet/Attribute/ClassType = FunctionKeyAggregateSum
FunctionKeyAggregate/FunctionKeyAggregateSum/__TOCDet/Attribute/Description = Sums the given properties.0x000D0x000A0x000D0x000AAny property not convertible to type of double is ignored.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyAggregate/FunctionKeyAggregateSum/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyDate/__TOCDet/Assembly = ARCQuery
FunctionKeyDate/__TOCDet/Description = Formats a date without time component.0x000D0x000A0x000D0x000AUses format 'yyyy-MM-dd'.0x000D0x000A0x000D0x000AExample: '2021-03-02 14:35:00' becomes '2021-03-02'.0x000D0x000A0x000D0x000ANote: For dates that have 'no' time-component, like '2021-03-02 00:00:00.000', -ConvertObjectToString- will use only the date information, like '2021-03-02', leaving -FunctionKeyDate- somewhat superfluous.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyDate/__TOCDet/DocFragType = Class
FunctionKeyDate/__TOCDet/Name = FunctionKeyDate
FunctionKeyDate/__TOCDet/Namespace = ARCQuery
FunctionKeyDate/__TOCDet/Type = FunctionKeyDate
FunctionKeyDate/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyDate/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyDate/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyDate/__TOCDet/Attribute/ClassType = FunctionKeyDate
FunctionKeyDate/__TOCDet/Attribute/Description = Formats a date without time component.0x000D0x000A0x000D0x000AUses format 'yyyy-MM-dd'.0x000D0x000A0x000D0x000AExample: '2021-03-02 14:35:00' becomes '2021-03-02'.0x000D0x000A0x000D0x000ANote: For dates that have 'no' time-component, like '2021-03-02 00:00:00.000', -ConvertObjectToString- will use only the date information, like '2021-03-02', leaving -FunctionKeyDate- somewhat superfluous.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyDate/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyDayOfWeek/__TOCDet/Assembly = ARCQuery
FunctionKeyDayOfWeek/__TOCDet/Description = Extracts DayOfWeek from field like 'Monday', 'Tuesday' and so on.0x000D0x000A0x000D0x000ATODO: Consider sorting issues here.0x000D0x000ATODO: Create alternative, DayOfWeekInt or similar for integer-representation.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyDayOfWeek/__TOCDet/DocFragType = Class
FunctionKeyDayOfWeek/__TOCDet/Name = FunctionKeyDayOfWeek
FunctionKeyDayOfWeek/__TOCDet/Namespace = ARCQuery
FunctionKeyDayOfWeek/__TOCDet/Type = FunctionKeyDayOfWeek
FunctionKeyDayOfWeek/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyDayOfWeek/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyDayOfWeek/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyDayOfWeek/__TOCDet/Attribute/ClassType = FunctionKeyDayOfWeek
FunctionKeyDayOfWeek/__TOCDet/Attribute/Description = Extracts DayOfWeek from field like 'Monday', 'Tuesday' and so on.0x000D0x000A0x000D0x000ATODO: Consider sorting issues here.0x000D0x000ATODO: Create alternative, DayOfWeekInt or similar for integer-representation.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyDayOfWeek/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyDouble/__TOCDet/Assembly = ARCQuery
FunctionKeyDouble/__TOCDet/Description = Converts an integer to a double (decimal value).0x000D0x000A0x000D0x000AUseful in order to force a division to be of type double (with decimals) (see -BinaryOperatorKey-).0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyDouble/__TOCDet/DocFragType = Class
FunctionKeyDouble/__TOCDet/Name = FunctionKeyDouble
FunctionKeyDouble/__TOCDet/Namespace = ARCQuery
FunctionKeyDouble/__TOCDet/Type = FunctionKeyDouble
FunctionKeyDouble/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyDouble/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyDouble/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyDouble/__TOCDet/Attribute/ClassType = FunctionKeyDouble
FunctionKeyDouble/__TOCDet/Attribute/Description = Converts an integer to a double (decimal value).0x000D0x000A0x000D0x000AUseful in order to force a division to be of type double (with decimals) (see -BinaryOperatorKey-).0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyDouble/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyFirstLine/__TOCDet/Assembly = ARCQuery
FunctionKeyFirstLine/__TOCDet/Description = Extracts first line from string of text.0x000D0x000A0x000D0x000AUseful for instance in tables with lots of text, when you want a compact presentation.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyFirstLine/__TOCDet/DocFragType = Class
FunctionKeyFirstLine/__TOCDet/Name = FunctionKeyFirstLine
FunctionKeyFirstLine/__TOCDet/Namespace = ARCQuery
FunctionKeyFirstLine/__TOCDet/Type = FunctionKeyFirstLine
FunctionKeyFirstLine/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyFirstLine/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyFirstLine/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyFirstLine/__TOCDet/Attribute/ClassType = FunctionKeyFirstLine
FunctionKeyFirstLine/__TOCDet/Attribute/Description = Extracts first line from string of text.0x000D0x000A0x000D0x000AUseful for instance in tables with lots of text, when you want a compact presentation.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyFirstLine/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyHourMinute/__TOCDet/Assembly = ARCQuery
FunctionKeyHourMinute/__TOCDet/Description = Formats a timespan with only the hour and minute part. Uses format hh:mm.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyHourMinute/__TOCDet/DocFragType = Class
FunctionKeyHourMinute/__TOCDet/Name = FunctionKeyHourMinute
FunctionKeyHourMinute/__TOCDet/Namespace = ARCQuery
FunctionKeyHourMinute/__TOCDet/Type = FunctionKeyHourMinute
FunctionKeyHourMinute/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyHourMinute/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyHourMinute/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyHourMinute/__TOCDet/Attribute/ClassType = FunctionKeyHourMinute
FunctionKeyHourMinute/__TOCDet/Attribute/Description = Formats a timespan with only the hour and minute part. Uses format hh:mm.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyHourMinute/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyInt/__TOCDet/Assembly = ARCQuery
FunctionKeyInt/__TOCDet/Description = Rounds a double value to the nearest integer (uses .NET data type Int64 (long)).0x000D0x000A(formulae used is: '(long)(dbl + .5)').0x000D0x000A0x000D0x000ATODO: Throws exception if double value is too big. Fix this (do not return any value in such a case maybe?)0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyInt/__TOCDet/DocFragType = Class
FunctionKeyInt/__TOCDet/Name = FunctionKeyInt
FunctionKeyInt/__TOCDet/Namespace = ARCQuery
FunctionKeyInt/__TOCDet/Type = FunctionKeyInt
FunctionKeyInt/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyInt/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyInt/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyInt/__TOCDet/Attribute/ClassType = FunctionKeyInt
FunctionKeyInt/__TOCDet/Attribute/Description = Rounds a double value to the nearest integer (uses .NET data type Int64 (long)).0x000D0x000A(formulae used is: '(long)(dbl + .5)').0x000D0x000A0x000D0x000ATODO: Throws exception if double value is too big. Fix this (do not return any value in such a case maybe?)0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyInt/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyLength/__TOCDet/Assembly = ARCQuery
FunctionKeyLength/__TOCDet/Description = Returns length of (string) value of field, like 4 for 'John'.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyLength/__TOCDet/DocFragType = Class
FunctionKeyLength/__TOCDet/Name = FunctionKeyLength
FunctionKeyLength/__TOCDet/Namespace = ARCQuery
FunctionKeyLength/__TOCDet/Type = FunctionKeyLength
FunctionKeyLength/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyLength/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyLength/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyLength/__TOCDet/Attribute/ClassType = FunctionKeyLength
FunctionKeyLength/__TOCDet/Attribute/Description = Returns length of (string) value of field, like 4 for 'John'.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyLength/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyMonth/__TOCDet/Assembly = ARCQuery
FunctionKeyMonth/__TOCDet/Description = Extracts month component from field like '2020-12-09' becoming '12'.0x000D0x000A0x000D0x000ANote: In many cases you probably want to use -FunctionKeyYearMonth- instead of -FunctionKeyMonth-.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyMonth/__TOCDet/DocFragType = Class
FunctionKeyMonth/__TOCDet/Name = FunctionKeyMonth
FunctionKeyMonth/__TOCDet/Namespace = ARCQuery
FunctionKeyMonth/__TOCDet/Type = FunctionKeyMonth
FunctionKeyMonth/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyMonth/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyMonth/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyMonth/__TOCDet/Attribute/ClassType = FunctionKeyMonth
FunctionKeyMonth/__TOCDet/Attribute/Description = Extracts month component from field like '2020-12-09' becoming '12'.0x000D0x000A0x000D0x000ANote: In many cases you probably want to use -FunctionKeyYearMonth- instead of -FunctionKeyMonth-.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyMonth/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyQuarter/__TOCDet/Assembly = ARCQuery
FunctionKeyQuarter/__TOCDet/Description = Extracts quarter component from datetime field like '2020-12-09' becoming 'Q4'.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyQuarter/__TOCDet/DocFragType = Class
FunctionKeyQuarter/__TOCDet/Name = FunctionKeyQuarter
FunctionKeyQuarter/__TOCDet/Namespace = ARCQuery
FunctionKeyQuarter/__TOCDet/Type = FunctionKeyQuarter
FunctionKeyQuarter/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyQuarter/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyQuarter/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyQuarter/__TOCDet/Attribute/ClassType = FunctionKeyQuarter
FunctionKeyQuarter/__TOCDet/Attribute/Description = Extracts quarter component from datetime field like '2020-12-09' becoming 'Q4'.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyQuarter/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyTMB/__TOCDet/Assembly = ARCQuery
FunctionKeyTMB/__TOCDet/Description = TMB = Thousands, Millions, Billions.0x000D0x000A0x000D0x000AFormats big numbers in an easier to understand format as number of Thousands, number of Millions, number of Billions.0x000D0x000A(Note that K (Kilo) is used for Thousands, like 10K = 10 Thousand).0x000D0x000A0x000D0x000AUseful in economic reports where the magnitude of the numbers are more important than the exact numbers0x000D0x000A(Note: Sorting on the generated values is difficult as of Jul 2020, because it is done alphabetically).0x000D0x000A0x000D0x000ATODO: Introduce also KMGT for Kilo, Mega, Giga, Tera etc (powers of 1000), and KiMiGiTi for (powers of 1024).0x000D0x000A0x000D0x000ATODO: This function does not work well before 'ORDER BY' (-QueryExpressionOrderBy-), TODO: and we can not use it AFTER 'ORDER BY', because TODO: ordering is not kept between each -QueryExpression- (because keys are not required to be sorted in -IP-).TODO: Possible fix: Do not return PValue0x003Cstring0x003E but PValue0x003CTypeX0x003E where TypeX is understood p0x00E5 'ORDER BY' through TOOD: some standard .Net mechanism for comparing.0x000D0x000ATODO: The TypeX instance could then store both the double-value (for comparing) and its TMB-string representation (for displaying).0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyTMB/__TOCDet/DocFragType = Class
FunctionKeyTMB/__TOCDet/Name = FunctionKeyTMB
FunctionKeyTMB/__TOCDet/Namespace = ARCQuery
FunctionKeyTMB/__TOCDet/Type = FunctionKeyTMB
FunctionKeyTMB/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyTMB/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyTMB/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyTMB/__TOCDet/Attribute/ClassType = FunctionKeyTMB
FunctionKeyTMB/__TOCDet/Attribute/Description = TMB = Thousands, Millions, Billions.0x000D0x000A0x000D0x000AFormats big numbers in an easier to understand format as number of Thousands, number of Millions, number of Billions.0x000D0x000A(Note that K (Kilo) is used for Thousands, like 10K = 10 Thousand).0x000D0x000A0x000D0x000AUseful in economic reports where the magnitude of the numbers are more important than the exact numbers0x000D0x000A(Note: Sorting on the generated values is difficult as of Jul 2020, because it is done alphabetically).0x000D0x000A0x000D0x000ATODO: Introduce also KMGT for Kilo, Mega, Giga, Tera etc (powers of 1000), and KiMiGiTi for (powers of 1024).0x000D0x000A0x000D0x000ATODO: This function does not work well before 'ORDER BY' (-QueryExpressionOrderBy-), TODO: and we can not use it AFTER 'ORDER BY', because TODO: ordering is not kept between each -QueryExpression- (because keys are not required to be sorted in -IP-).TODO: Possible fix: Do not return PValue0x003Cstring0x003E but PValue0x003CTypeX0x003E where TypeX is understood p0x00E5 'ORDER BY' through TOOD: some standard .Net mechanism for comparing.0x000D0x000ATODO: The TypeX instance could then store both the double-value (for comparing) and its TMB-string representation (for displaying).0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyTMB/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyTotalHours/__TOCDet/Assembly = ARCQuery
FunctionKeyTotalHours/__TOCDet/Description = Converts a timespan to total hours (as an integer).0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyTotalHours/__TOCDet/DocFragType = Class
FunctionKeyTotalHours/__TOCDet/Name = FunctionKeyTotalHours
FunctionKeyTotalHours/__TOCDet/Namespace = ARCQuery
FunctionKeyTotalHours/__TOCDet/Type = FunctionKeyTotalHours
FunctionKeyTotalHours/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyTotalHours/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyTotalHours/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyTotalHours/__TOCDet/Attribute/ClassType = FunctionKeyTotalHours
FunctionKeyTotalHours/__TOCDet/Attribute/Description = Converts a timespan to total hours (as an integer).0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyTotalHours/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyTotalMinutes/__TOCDet/Assembly = ARCQuery
FunctionKeyTotalMinutes/__TOCDet/Description = Converts a timespan to total minutes (as an integer).0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyTotalMinutes/__TOCDet/DocFragType = Class
FunctionKeyTotalMinutes/__TOCDet/Name = FunctionKeyTotalMinutes
FunctionKeyTotalMinutes/__TOCDet/Namespace = ARCQuery
FunctionKeyTotalMinutes/__TOCDet/Type = FunctionKeyTotalMinutes
FunctionKeyTotalMinutes/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyTotalMinutes/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyTotalMinutes/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyTotalMinutes/__TOCDet/Attribute/ClassType = FunctionKeyTotalMinutes
FunctionKeyTotalMinutes/__TOCDet/Attribute/Description = Converts a timespan to total minutes (as an integer).0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyTotalMinutes/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyType/__TOCDet/Assembly = ARCQuery
FunctionKeyType/__TOCDet/Description = Returns the type of a property.0x000D0x000A0x000D0x000AMost useful for debugging AgoRapide itself, for instance to see what kind of object types are used to store values.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyType/__TOCDet/DocFragType = Class
FunctionKeyType/__TOCDet/Name = FunctionKeyType
FunctionKeyType/__TOCDet/Namespace = ARCQuery
FunctionKeyType/__TOCDet/Type = FunctionKeyType
FunctionKeyType/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyType/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyType/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyType/__TOCDet/Attribute/ClassType = FunctionKeyType
FunctionKeyType/__TOCDet/Attribute/Description = Returns the type of a property.0x000D0x000A0x000D0x000AMost useful for debugging AgoRapide itself, for instance to see what kind of object types are used to store values.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyType/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyWeek/__TOCDet/Assembly = ARCQuery
FunctionKeyWeek/__TOCDet/Description = Extract week-number from field according to ISO 8601.0x000D0x000A0x000D0x000AUses the System.Globalization.ISOWeek.GetWeekOfYear() method in .Net.0x000D0x000A0x000D0x000ASee also -FunctionKeyYearWeek-.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyWeek/__TOCDet/DocFragType = Class
FunctionKeyWeek/__TOCDet/Name = FunctionKeyWeek
FunctionKeyWeek/__TOCDet/Namespace = ARCQuery
FunctionKeyWeek/__TOCDet/Type = FunctionKeyWeek
FunctionKeyWeek/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyWeek/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyWeek/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyWeek/__TOCDet/Attribute/ClassType = FunctionKeyWeek
FunctionKeyWeek/__TOCDet/Attribute/Description = Extract week-number from field according to ISO 8601.0x000D0x000A0x000D0x000AUses the System.Globalization.ISOWeek.GetWeekOfYear() method in .Net.0x000D0x000A0x000D0x000ASee also -FunctionKeyYearWeek-.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyWeek/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyYear/__TOCDet/Assembly = ARCQuery
FunctionKeyYear/__TOCDet/Description = Extracts Year-component from field.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyYear/__TOCDet/DocFragType = Class
FunctionKeyYear/__TOCDet/Name = FunctionKeyYear
FunctionKeyYear/__TOCDet/Namespace = ARCQuery
FunctionKeyYear/__TOCDet/Type = FunctionKeyYear
FunctionKeyYear/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyYear/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyYear/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyYear/__TOCDet/Attribute/ClassType = FunctionKeyYear
FunctionKeyYear/__TOCDet/Attribute/Description = Extracts Year-component from field.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyYear/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyYearMonth/__TOCDet/Assembly = ARCQuery
FunctionKeyYearMonth/__TOCDet/Description = Extracts Year + Month component from field like 2020-06.0x000D0x000A0x000D0x000ASee also -FunctionKeyYearWeek-.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyYearMonth/__TOCDet/DocFragType = Class
FunctionKeyYearMonth/__TOCDet/Name = FunctionKeyYearMonth
FunctionKeyYearMonth/__TOCDet/Namespace = ARCQuery
FunctionKeyYearMonth/__TOCDet/Type = FunctionKeyYearMonth
FunctionKeyYearMonth/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyYearMonth/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyYearMonth/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyYearMonth/__TOCDet/Attribute/ClassType = FunctionKeyYearMonth
FunctionKeyYearMonth/__TOCDet/Attribute/Description = Extracts Year + Month component from field like 2020-06.0x000D0x000A0x000D0x000ASee also -FunctionKeyYearWeek-.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyYearMonth/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyYearQuarter/__TOCDet/Assembly = ARCQuery
FunctionKeyYearQuarter/__TOCDet/Description = Extracts Year + Quarter component from field like 2020Q1.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyYearQuarter/__TOCDet/DocFragType = Class
FunctionKeyYearQuarter/__TOCDet/Name = FunctionKeyYearQuarter
FunctionKeyYearQuarter/__TOCDet/Namespace = ARCQuery
FunctionKeyYearQuarter/__TOCDet/Type = FunctionKeyYearQuarter
FunctionKeyYearQuarter/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyYearQuarter/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyYearQuarter/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyYearQuarter/__TOCDet/Attribute/ClassType = FunctionKeyYearQuarter
FunctionKeyYearQuarter/__TOCDet/Attribute/Description = Extracts Year + Quarter component from field like 2020Q1.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyYearQuarter/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E
FunctionKeyYearWeek/__TOCDet/Assembly = ARCQuery
FunctionKeyYearWeek/__TOCDet/Description = Extract year and week number from field according to ISO 8601 like '2021-51'0x000D0x000A0x000D0x000AUses the System.Globalization.ISOWeek.GetWeekOfYear() and GetYear() methods in .Net.0x000D0x000A(Note: The date '2021-01-01' will for instance show as '2020-53'.)0x000D0x000A0x000D0x000ASee also -FunctionKeyYearMonth-.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyYearWeek/__TOCDet/DocFragType = Class
FunctionKeyYearWeek/__TOCDet/Name = FunctionKeyYearWeek
FunctionKeyYearWeek/__TOCDet/Namespace = ARCQuery
FunctionKeyYearWeek/__TOCDet/Type = FunctionKeyYearWeek
FunctionKeyYearWeek/__TOCDet/Attribute/AssemblyName = ARCQuery
FunctionKeyYearWeek/__TOCDet/Attribute/BaseTypes = FunctionKey
FunctionKeyYearWeek/__TOCDet/Attribute/ClassNamespace = ARCQuery
FunctionKeyYearWeek/__TOCDet/Attribute/ClassType = FunctionKeyYearWeek
FunctionKeyYearWeek/__TOCDet/Attribute/Description = Extract year and week number from field according to ISO 8601 like '2021-51'0x000D0x000A0x000D0x000AUses the System.Globalization.ISOWeek.GetWeekOfYear() and GetYear() methods in .Net.0x000D0x000A(Note: The date '2021-01-01' will for instance show as '2020-53'.)0x000D0x000A0x000D0x000ASee also -FunctionKeyYearMonth-.0x000D0x000A0x000D0x000ASee -SyntaxHelp-.
FunctionKeyYearWeek/__TOCDet/Attribute/Interfaces = ITypeDescriber0x003BIEquatable0xoooo003CFunctionKey0xoooo003E

Edit single sub keys only: __TOCDet / FunctionKeyAggregate / FunctionKeyDate / FunctionKeyDayOfWeek / FunctionKeyDouble / FunctionKeyFirstLine / FunctionKeyHourMinute / FunctionKeyInt / FunctionKeyLength / FunctionKeyMonth / FunctionKeyQuarter / FunctionKeyTMB / FunctionKeyTotalHours / FunctionKeyTotalMinutes / FunctionKeyType / FunctionKeyWeek / FunctionKeyYear / FunctionKeyYearMonth / FunctionKeyYearQuarter / FunctionKeyYearWeek

Generated 2025-10-30 09:18:26.890 UTC