Functions

The functions are sorted on their function group, and on alphabetical order. The SQL compatibility is given by either "Yes" or "No".

Aggregation

Function	SQL compatible
Average	No
Count	Yes
First	No
Last	No
Max	Yes
Min	Yes
Sum	Yes

Concepts

Function	SQL compatible
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

Function	SQL compatible
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

Environment

Function	SQL compatible
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

Files

Function	SQL compatible
FileName	No
FileSize	No
FileUrl	No
MimeType	No

Lists

Function	SQL compatible
Distinct	No
IsNewRow	No
IsOnRow	No
List	No
NameOf	Yes
RowID	Yes

Math

Function	SQL compatible
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

Security

Function	SQL compatible
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

Text

Function	SQL compatible
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

Validation

Function	SQL compatible
HasValue	Yes
IsEmpty	Yes
IsKnown	Yes
IsUnknown	Yes
IsValidBankaccount	No
IsValidBSN	No
IsValidBTW	No
IsValidEmailAddress	No
IsValidIBAN	No
IsValidPhonenumber	No
IsValidURL	No

Localization

Function	SQL compatible
AvailableLanguages	Yes
CurrentLanguages	Yes
CurrentTimezone	Yes
LanguageStrategy	Yes
Languages in WEM	Yes