Functions

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

Function
SQL compatible

Average

No

Count

Yes

First

No

Last

No

Max

Yes

Min

Yes

Sum

Yes

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

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

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

Function
SQL compatible

FileName

No

FileSize

No

FileUrl

No

MimeType

No

Function
SQL compatible

Distinct

No

IsNewRow

No

IsOnRow

No

List

No

NameOf

Yes

RowID

Yes

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

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

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

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

Function
SQL compatible

AvailableLanguages

Yes

CurrentLanguages

Yes

CurrentTimezone

Yes

LanguageStrategy

Yes

Languages in WEM

Yes

Last updated