Functions
The functions are sorted on their function group, and on alphabetical order. The SQL compatibility is given by either "Yes" or "No".
Average
No
Count
Yes
First
No
Last
No
Max
Yes
Min
Yes
Sum
Yes
ConceptID
No
Description
No
FindConcepts
No
GetAncestors
No
GetChildren
No
GetDescendants
No
GetParent
No
Intersection
No
LocalName
No
Synonyms
No
ToConcept
No
Union
No
Date
No
DateDiff
No
DateOnly
No
DatePart
No
DateOfWeek
No
FromUnixTimestamp
No
MoveDate
Yes
Now
Yes
TimeOfDay
No
Today
Yes
ToDuration
No
ToLocal
No
ToUnixTimestamp
No
ToUTC
No
UTCNow
Yes
UTCToday
Yes
CountryCode
Yes
CountryName
Yes
Hostname
Yes
IPAddress
Yes
IsFirstRequest
Yes
IsHttps
Yes
IsPreview
Yes
IsStaging
Yes
IsLive
Yes
NodeTrail
Yes
PortalID
Yes
ProjectID
Yes
ProjectName
Yes
Setting
Yes
URLPath
Yes
FileName
No
FileSize
No
FileUrl
No
MimeType
No
Distinct
No
IsNewRow
No
IsOnRow
No
List
No
NameOf
Yes
RowID
Yes
Abs
No
Ceiling
No
Cos
No
Distance
No
Exp
No
Floor
No
Log
No
Log10
No
Pi
Yes
Pow
No
Random
No
Round
No
Sin
No
Sqrt
No
ToNumber
No
AesDecrypt
No
AesEncrypt
No
Aeslv
No
AesKey
No
CreateJsonWebTokenH256
No
HmacSha256
No
Md5
No
Password
No
PasswordStrength
No
Pdkdf2
No
Sha1
No
Sha256
No
Totp
No
AsText
No
Base32ToText
No
Base64ToText
No
CompareFuzzy
No
Concat
No
Contains
No
FormatDate
No
FormatDuration
No
FormatNumber
No
Guid
No
HexToText
No
HtmlAttributeEncode
No
HtmlEncode
No
IndexOf
No
JavascriptEncode
No
JsonEncode
No
Length
No
Padl
No
Padr
No
RegExIsMatch
No
RegExMatches
No
RegExReplace
No
Replace
No
Split
No
StringPart
No
SubString
No
ToBase32
No
ToBase64
No
ToBase64Url
No
ToHex
No
ToLower
No
ToRichText
No
ToString
No
ToTitleCase
No
ToUpper
No
Trim
No
UrlDecode
No
UrlEncode
No
XmlAttributeEncode
No
XmlEncode
No
XPath
No
XPathList
No
XPathNumber
No
HasValue
Yes
IsEmpty
Yes
IsKnown
Yes
IsUnknown
Yes
IsValidBankaccount
No
IsValidBSN
No
IsValidBTW
No
IsValidEmailAddress
No
IsValidIBAN
No
IsValidPhonenumber
No
IsValidURL
No
AvailableLanguages
Yes
CurrentLanguages
Yes
CurrentTimezone
Yes
LanguageStrategy
Yes
Languages in WEM
Yes
Last updated