Wednesday 9 January 2013

Microsoft Dynamics AX 2012 R2 - X++ Function Categories and their Functions


This blog lists every X++ built-in function by category.

Descriptions of Categories


The following lists only the categories of X++ functions. Each category is described. These categories help people to understand the many functions, but the categories do not represent any formal construct in Microsoft Dynamics AX.

Category: Business
Description: Functions that input financial data and calculate formulas.

Category: Compiler Verified (also named Intrinsic)
Description: Functions that have their input value verified by the compiler. If the input value is not found to match any existing object in the Application Object Tree (AOT), the compiler issues an error. The inputs to these functions must be literals, because the compiler cannot determine the value that a variable contains at run time.

Category: Container
Description: Functions that operate on the container data type of X++.

Category: Convert
Description: Functions that translate data of one type into data of another type.

Category: Date
Description: Functions that operate on the date data type.

Category: Enum
Description: Functions that operate on enum objects.

Category: Math
Description: Functions that perform mathematical calculations.

Category: Miscellaneous
Description: Functions that do not belong to any specific category.

Category: Reflection
Description: Functions that access the metadata about objects and return other metadata about them.

Category: Session
Description: Functions that change or report on the context of the current user connection.

Category: String
Description: Functions that operate on the str data type.


Categorization of X++ Functions


The following lists the X++ functions that belong in each previous category.

Category: Business
X++ function:
  • cTerm
  • ddb
  • dg
  • fv
  • idg
  • intvMax
  • intvName
  • intvNo
  • intvNorm
  • pmt
  • pt
  • pv
  • rate
  • sln
  • syd
  • term

Category: Compiler Verified (also named Intrinsic)
X++ function:
  • attributeStr
  • classNum
  • classStr
  • configurationKeyNum
  • configurationKeyStr
  • datasetStr
  • enumNum
  • enumStr
  • evalBuf
  • extendedTypeNum
  • extendedTypeStr
  • fieldNum
  • fieldPName
  • fieldStr
  • formControlStr
  • formStr
  • identifierstr
  • indexNum
  • indexStr
  • licenseCodeNum
  • licenseCodeStr
  • literalStr
  • menuItemActionStr
  • menuItemDisplayStr
  • menuItemOutputStr
  • menuStr
  • methodStr
  • perspectiveNum
  • perspectiveStr
  • queryDataSourceStr
  • queryStr
  • reportStr
  • resourceStr
  • runBuf
  • securityKeyNum
  • securityKeyStr
  • ssrsReportStr
  • staticMethodStr
  • tableCollectionStr
  • tableFieldGroupStr
  • tableMethodStr
  • tableNum
  • tablePName
  • tableStaticMethodStr
  • tableStr
  • varStr
  • webActionItemStr
  • webDisplayContentItemStr
  • webFormStr
  • webletItemStr
  • webMenuStr
  • webOutputContentItemStr
  • webPageDefStr
  • webReportStr
  • webSiteDefStr
  • webSiteTempStr
  • webStaticFileStr
  • webUrlItemStr
  • webWebpartStr
  • workflowApprovalStr
  • workflowCategoryStr
  • workflowTaskStr
  • workflowTemplateStr

Category: Container
X++ function:
  • conDel
  • conFind
  • conIns
  • conLen
  • conNull
  • conPeek
  • conPoke
   
Category: Convert
X++ function:
  • any2Enum
  • any2Date
  • any2Guid
  • any2Int
  • any2Int64
  • any2Real
  • any2Str
  • char2Num
  • Date2Num
  • Date2Str
  • Datetime2Str
  • formattedStr2Num
  • guid2Str
  • int2Str
  • int642Str
  • num2Char
  • num2Date
  • num2Str
  • str2Enum
  • str2Date
  • str2Datetime
  • str2Guid
  • str2Int
  • str2Int64
  • str2Num
  • str2Time
  • time2Str
  • uint2Str
   
Category: Date
X++ function:
  • dayName
  • dayOfMth
  • dayOfWk
  • dayOfYr
  • endMth
  • maxDate
  • mkDate
  • mthName
  • mthOfYr
  • nextMth
  • nextQtr
  • nextYr
  • prevMth
  • prevQtr
  • prevYr
  • timeNow
  • today
  • wkOfYr
  • year

Category: Enum
X++ function:
  • enum2Str
  • enumCnt

Category: Math
X++ function: 
  • abs
  • acos
  • asin
  • atan
  • corrFlagGet
  • corrFlagSet
  • cos
  • cosh
  • decRound
  • exp
  • exp10
  • frac
  • log10
  • logN
  • power
  • round
  • sin
  • sinh
  • tan
  • tanh
  • trunc
   
Category: Miscellaneous
X++ function:
  • beep
  • classIdGet
  • dimOf
  • getPrefix
  • max
  • maxInt
  • min
  • minInt
  • newGuid
  • setPrefix
  • sleep
  • systemDateget
  • systemDateset

Category: Reflection
X++ function:
  • fieldId2Name
  • fieldId2PName
  • fieldName2Id
  • indexId2Name
  • indexName2Id
  • refPrintAll
  • tableId2Name
  • tableId2PName
  • tableName2Id
  • typeOf
   
Category: Session
X++ function:
  • curExt
  • curUserId
  • getCurrentPartition
  • getCurrentPartitionRecId
  • SessionId
  • funcName
  • prmIsDefault
  • runAs
   
Category: String
X++ function:
  • match
  • strAlpha
  • strCmp
  • strColSeq
  • strDel
  • strFind
  • strFmt
  • strIns
  • strKeep
  • strLen
  • strLine
  • strLTrim
  • strLwr
  • strNFind
  • strPoke
  • strPrompt
  • strRem
  • strRep
  • strRTrim
  • strScan
  • strUpr
  • subStr

My above blog is based on Microsoft's Official information.

I hope this blog about 'Microsoft Dynamics AX 2012 R2 - X++ Function Categories and their Functions' was informative. Please feel free to leave your comments.

No comments:

Post a Comment