# WEM Reference

- [WEM Expressions Reference](/platform/wemreference/wem-expressions-reference.md): Everything about WEM Functions Keywords, Operators, Data Types and WEMScript to spice up your application.
- [Functions](/platform/wemreference/functions.md)
- [Aggregation](/platform/wemreference/functions/aggregation.md)
- [Average](/platform/wemreference/functions/aggregation/average.md)
- [Count](/platform/wemreference/functions/aggregation/count.md)
- [First](/platform/wemreference/functions/aggregation/first.md)
- [Last](/platform/wemreference/functions/aggregation/last.md)
- [Max](/platform/wemreference/functions/aggregation/max.md)
- [Min](/platform/wemreference/functions/aggregation/min.md)
- [Sum](/platform/wemreference/functions/aggregation/sum.md)
- [Concepts](/platform/wemreference/functions/concepts.md)
- [ConceptId](/platform/wemreference/functions/concepts/conceptid.md)
- [Description](/platform/wemreference/functions/concepts/description.md)
- [FindConcepts](/platform/wemreference/functions/concepts/findconcepts.md)
- [GetAncestors](/platform/wemreference/functions/concepts/getancestors.md)
- [GetChildren](/platform/wemreference/functions/concepts/getchildren.md)
- [GetDescendants](/platform/wemreference/functions/concepts/getdescendants.md)
- [GetParent](/platform/wemreference/functions/concepts/getparent.md)
- [Intersection](/platform/wemreference/functions/concepts/intersection.md)
- [LocalName](/platform/wemreference/functions/concepts/localname.md)
- [Synonyms](/platform/wemreference/functions/concepts/synonyms.md)
- [ToConcept](/platform/wemreference/functions/concepts/toconcept.md)
- [Union](/platform/wemreference/functions/concepts/union.md)
- [Date](/platform/wemreference/functions/date.md)
- [Date](/platform/wemreference/functions/date/date.md)
- [DateDiff](/platform/wemreference/functions/date/datediff.md)
- [DateOnly](/platform/wemreference/functions/date/dateonly.md)
- [DatePart](/platform/wemreference/functions/date/datepart.md)
- [DayOfWeek](/platform/wemreference/functions/date/dayofweek.md)
- [FromUnixTimestamp](/platform/wemreference/functions/date/fromunixtimestamp.md)
- [MoveDate](/platform/wemreference/functions/date/movedate.md)
- [Now](/platform/wemreference/functions/date/now.md)
- [TimeOfDay](/platform/wemreference/functions/date/timeofday.md)
- [Today](/platform/wemreference/functions/date/today.md)
- [ToDuration](/platform/wemreference/functions/date/toduration.md)
- [ToLocal](/platform/wemreference/functions/date/tolocal.md)
- [ToUnixTimestamp](/platform/wemreference/functions/date/tounixtimestamp.md)
- [ToUTC](/platform/wemreference/functions/date/toutc.md)
- [UTCNow](/platform/wemreference/functions/date/utcnow.md)
- [UTCToday](/platform/wemreference/functions/date/utctoday.md)
- [Environment](/platform/wemreference/functions/environment.md)
- [CountryCode](/platform/wemreference/functions/environment/countrycode.md)
- [CountryName](/platform/wemreference/functions/environment/countryname.md)
- [Hostname](/platform/wemreference/functions/environment/hostname.md)
- [IpAddress](/platform/wemreference/functions/environment/ipaddress.md)
- [IsFirstRequest](/platform/wemreference/functions/environment/isfirstrequest.md)
- [IsHttps](/platform/wemreference/functions/environment/ishttps.md)
- [IsPreview](/platform/wemreference/functions/environment/ispreview.md)
- [IsStaging](/platform/wemreference/functions/environment/isstaging.md)
- [IsLive](/platform/wemreference/functions/environment/islive.md)
- [NodeTrail](/platform/wemreference/functions/environment/nodetrail.md)
- [PortalId](/platform/wemreference/functions/environment/portalid.md)
- [ProjectId](/platform/wemreference/functions/environment/projectid.md)
- [ProjectName](/platform/wemreference/functions/environment/projectname.md)
- [Setting](/platform/wemreference/functions/environment/setting.md)
- [UrlPath](/platform/wemreference/functions/environment/urlpath.md)
- [Files](/platform/wemreference/functions/files.md)
- [FileName](/platform/wemreference/functions/files/filename.md)
- [FileSize](/platform/wemreference/functions/files/filesize.md)
- [FileUrl](/platform/wemreference/functions/files/fileurl.md)
- [MimeType](/platform/wemreference/functions/files/mimetype.md)
- [Lists](/platform/wemreference/functions/lists.md)
- [Distinct](/platform/wemreference/functions/lists/distinct.md)
- [IsNewRow](/platform/wemreference/functions/lists/isnewrow.md)
- [IsOnRow](/platform/wemreference/functions/lists/isonrow.md)
- [List](/platform/wemreference/functions/lists/list.md)
- [NameOf](/platform/wemreference/functions/lists/nameof.md)
- [RowId](/platform/wemreference/functions/lists/rowid.md)
- [Math](/platform/wemreference/functions/math.md)
- [Abs](/platform/wemreference/functions/math/abs.md)
- [Ceiling](/platform/wemreference/functions/math/ceiling.md)
- [Cos](/platform/wemreference/functions/math/cos.md)
- [Distance](/platform/wemreference/functions/math/distance.md)
- [Exp](/platform/wemreference/functions/math/exp.md)
- [Floor](/platform/wemreference/functions/math/floor.md)
- [Log](/platform/wemreference/functions/math/log.md)
- [Log10](/platform/wemreference/functions/math/log10.md)
- [Pi](/platform/wemreference/functions/math/pi.md)
- [Pow](/platform/wemreference/functions/math/pow.md)
- [Random](/platform/wemreference/functions/math/random.md)
- [Round](/platform/wemreference/functions/math/round.md)
- [Sin](/platform/wemreference/functions/math/sin.md)
- [Sqrt](/platform/wemreference/functions/math/sqrt.md)
- [ToNumber](/platform/wemreference/functions/math/tonumber.md)
- [Security](/platform/wemreference/functions/security.md)
- [AesDecrypt](/platform/wemreference/functions/security/aesdecrypt.md)
- [AesEncrypt](/platform/wemreference/functions/security/aesencrypt.md)
- [AesIv](/platform/wemreference/functions/security/aesiv.md)
- [AesKey](/platform/wemreference/functions/security/aeskey.md)
- [CreateJsonWebTokenH256](/platform/wemreference/functions/security/createjsonwebtokenh256.md)
- [HmacSha256](/platform/wemreference/functions/security/hmacsha256.md)
- [Md5](/platform/wemreference/functions/security/md5.md)
- [Password](/platform/wemreference/functions/security/password.md)
- [PasswordStrength](/platform/wemreference/functions/security/passwordstrength.md)
- [Pbkdf2](/platform/wemreference/functions/security/pbkdf2.md)
- [Sha1](/platform/wemreference/functions/security/sha1.md)
- [Sha256](/platform/wemreference/functions/security/sha256.md)
- [Totp](/platform/wemreference/functions/security/totp.md)
- [Text](/platform/wemreference/functions/text.md)
- [AsText](/platform/wemreference/functions/text/astext.md)
- [Base32ToText](/platform/wemreference/functions/text/base32totext.md)
- [Base64ToText](/platform/wemreference/functions/text/base64totext.md)
- [CompareFuzzy](/platform/wemreference/functions/text/comparefuzzy.md)
- [Concat](/platform/wemreference/functions/text/concat.md)
- [Contains](/platform/wemreference/functions/text/contains.md)
- [FormatDate](/platform/wemreference/functions/text/formatdate.md)
- [FormatDuration](/platform/wemreference/functions/text/formatduration.md)
- [FormatNumber](/platform/wemreference/functions/text/formatnumber.md)
- [Guid](/platform/wemreference/functions/text/guid.md)
- [HexToText](/platform/wemreference/functions/text/hextotext.md)
- [HtmlAttributeEncode](/platform/wemreference/functions/text/htmlattributeencode.md)
- [HtmlEncode](/platform/wemreference/functions/text/htmlencode.md)
- [IndexOf](/platform/wemreference/functions/text/indexof.md)
- [JavascriptEncode](/platform/wemreference/functions/text/javascriptencode.md)
- [JsonEncode](/platform/wemreference/functions/text/jsonencode.md)
- [Length](/platform/wemreference/functions/text/length.md)
- [Padl](/platform/wemreference/functions/text/padl.md)
- [Padr](/platform/wemreference/functions/text/padr.md)
- [RegExIsMatch](/platform/wemreference/functions/text/regexismatch.md)
- [RegExMatches](/platform/wemreference/functions/text/regexmatches.md)
- [RegExReplace](/platform/wemreference/functions/text/regexreplace.md)
- [Replace](/platform/wemreference/functions/text/replace.md)
- [Split](/platform/wemreference/functions/text/split.md)
- [StringPart](/platform/wemreference/functions/text/stringpart.md)
- [SubString](/platform/wemreference/functions/text/substring.md)
- [ToBase32](/platform/wemreference/functions/text/tobase32.md)
- [ToBase64](/platform/wemreference/functions/text/tobase64.md)
- [ToBase64Url](/platform/wemreference/functions/text/tobase64url.md)
- [ToHex](/platform/wemreference/functions/text/tohex.md)
- [ToLower](/platform/wemreference/functions/text/tolower.md)
- [ToRichText](/platform/wemreference/functions/text/torichtext.md)
- [ToString](/platform/wemreference/functions/text/tostring.md)
- [ToTitleCase](/platform/wemreference/functions/text/totitlecase.md)
- [ToUpper](/platform/wemreference/functions/text/toupper.md)
- [Trim](/platform/wemreference/functions/text/trim.md)
- [UrlDecode](/platform/wemreference/functions/text/urldecode.md)
- [UrlEncode](/platform/wemreference/functions/text/urlencode.md)
- [XmlAttributeEncode](/platform/wemreference/functions/text/xmlattributeencode.md)
- [XmlEncode](/platform/wemreference/functions/text/xmlencode.md)
- [XPath](/platform/wemreference/functions/text/xpath.md)
- [XPathList](/platform/wemreference/functions/text/xpathlist.md)
- [XPathNumber](/platform/wemreference/functions/text/xpathnumber.md)
- [Validation](/platform/wemreference/functions/validation.md)
- [HasValue](/platform/wemreference/functions/validation/hasvalue.md)
- [IsEmpty](/platform/wemreference/functions/validation/isempty.md)
- [IsKnown](/platform/wemreference/functions/validation/isknown.md)
- [IsUnknown](/platform/wemreference/functions/validation/isunknown.md)
- [IsValidBankaccount](/platform/wemreference/functions/validation/isvalidbankaccount.md)
- [IsValidBSN](/platform/wemreference/functions/validation/isvalidbsn.md)
- [IsValidBTW](/platform/wemreference/functions/validation/isvalidbtw.md)
- [IsValidEmailAddress](/platform/wemreference/functions/validation/isvalidemailaddress.md)
- [IsValidIBAN](/platform/wemreference/functions/validation/isvalidiban.md)
- [IsValidPhonenumber](/platform/wemreference/functions/validation/isvalidphonenumber.md)
- [IsValidURL](/platform/wemreference/functions/validation/isvalidurl.md)
- [Localization](/platform/wemreference/functions/localization.md)
- [AvailableLanguages](/platform/wemreference/functions/localization/availablelanguages.md)
- [CurrentLanguage](/platform/wemreference/functions/localization/currentlanguage.md)
- [CurrentTimezone](/platform/wemreference/functions/localization/currenttimezone.md)
- [LanguageStrategy](/platform/wemreference/functions/localization/languagestrategy.md)
- [Languages in WEM](/platform/wemreference/functions/localization/languages-in-wem.md)
- [Keywords](/platform/wemreference/keywords.md)
- [Contains](/platform/wemreference/keywords/contains.md)
- [Concepts](/platform/wemreference/keywords/concepts.md)
- [Ancestor of](/platform/wemreference/keywords/concepts/ancestor-of.md)
- [Child of](/platform/wemreference/keywords/concepts/child-of.md)
- [Concept](/platform/wemreference/keywords/concepts/concept.md)
- [Descendant of](/platform/wemreference/keywords/concepts/descendant-of.md)
- [Overlaps](/platform/wemreference/keywords/concepts/overlaps.md)
- [Range of](/platform/wemreference/keywords/concepts/range-of.md)
- [Parent of](/platform/wemreference/keywords/concepts/parent-of.md)
- [Contains](/platform/wemreference/keywords/concepts/contains.md)
- [Environment](/platform/wemreference/keywords/environment.md)
- [ApplicationRoot](/platform/wemreference/keywords/environment/applicationroot.md)
- [Platform](/platform/wemreference/keywords/environment/platform.md)
- [Lists](/platform/wemreference/keywords/lists.md)
- [In](/platform/wemreference/keywords/lists/in.md)
- [Of](/platform/wemreference/keywords/lists/of.md)
- [Where](/platform/wemreference/keywords/lists/where.md)
- [Contains](/platform/wemreference/keywords/lists/contains.md)
- [All](/platform/wemreference/keywords/lists/all.md)
- [Logic](/platform/wemreference/keywords/logic.md): Keywords to use in logical expressions.
- [And](/platform/wemreference/keywords/logic/and.md)
- [Not](/platform/wemreference/keywords/logic/not.md)
- [Or](/platform/wemreference/keywords/logic/or.md)
- [Choose](/platform/wemreference/keywords/logic/choose.md)
- [If Then Else](/platform/wemreference/keywords/logic/ifelse.md)
- [Mobile](/platform/wemreference/keywords/mobile.md): These keywords are only available in Native Mobile Apps projects
- [BatteryLife](/platform/wemreference/keywords/mobile/batterylife.md): Only available in Native Mobile Apps projects
- [BuildVersion](/platform/wemreference/keywords/mobile/buildversion.md): Only available in Native Mobile Apps projects
- [ConnectivityTypes](/platform/wemreference/keywords/mobile/connectivitytypes.md)
- [DeviceId](/platform/wemreference/keywords/mobile/deviceid.md): Only available in Native Mobile Apps projects
- [DeviceName](/platform/wemreference/keywords/mobile/devicename.md): Only available in Native Mobile Apps projects
- [IsDevelopmentBuild](/platform/wemreference/keywords/mobile/isdevelopmentbuild.md): Only available in Native Mobile Apps projects
- [IsDistributionBuild](/platform/wemreference/keywords/mobile/isdistributionbuild.md): Only available in Native Mobile Apps projects
- [Text](/platform/wemreference/keywords/text.md)
- [Contains](/platform/wemreference/keywords/text/contains.md)
- [Ends with](/platform/wemreference/keywords/text/ends-with.md)
- [NewLine](/platform/wemreference/keywords/text/newline.md)
- [Starts with](/platform/wemreference/keywords/text/starts-with.md)
- [Operators](/platform/wemreference/operators.md): An alphabetical list of all expression operators.
- [Addition +](/platform/wemreference/operators/addition.md): Operator: +
- [Division /](/platform/wemreference/operators/division.md): Operator: /
- [Equality =](/platform/wemreference/operators/equality.md): Operator: =
- [Equality-strong ==](/platform/wemreference/operators/equality-strong.md): Operator: ==
- [Greater-than >](/platform/wemreference/operators/greater-than.md): Operator: >
- [Greater-than-or-equal >=](/platform/wemreference/operators/greater-than-or-equal.md): Operator: >=
- [If-unknown ?](/platform/wemreference/operators/if-unknown.md): Operator: ?
- [Inversion -](/platform/wemreference/operators/inversion.md): Operator: -
- [Less-than <](/platform/wemreference/operators/less-than.md): Operator: <
- [Less-than-or-equal <=](/platform/wemreference/operators/less-than-or-equal.md): Operator: <=
- [Logical-and &, and](/platform/wemreference/operators/logical-and.md): Operator: & , and
- [Logical-not !, not](/platform/wemreference/operators/logical-not.md): Operator: ! , not
- [Logical-or |, or](/platform/wemreference/operators/logical-or.md): Operator: | , or
- [Modulo %](/platform/wemreference/operators/modulo.md): Operator: %
- [Multiplication \*](/platform/wemreference/operators/multiplication.md): Operator: \*
- [Power ^](/platform/wemreference/operators/power.md): Operator: ^
- [Subtraction -](/platform/wemreference/operators/subtraction.md): Operator: -
- [Unequality <>](/platform/wemreference/operators/unequality.md): Operator: <>
- [Data Types](/platform/wemreference/data-types.md)
- [Text](/platform/wemreference/data-types/text.md)
- [Number](/platform/wemreference/data-types/number.md)
- [Yes / No (Boolean)](/platform/wemreference/data-types/yes-no-boolean.md)
- [Date Time](/platform/wemreference/data-types/date-time.md)
- [Duration](/platform/wemreference/data-types/duration.md)
- [File](/platform/wemreference/data-types/file.md)
- [Rich Text](/platform/wemreference/data-types/rich-text.md)
- [Concept](/platform/wemreference/data-types/concept.md)
- [Conceptset](/platform/wemreference/data-types/conceptset.md)
- [Reference](/platform/wemreference/data-types/reference.md)
- [SQL Compatibility](/platform/wemreference/sql-compatibility.md)
- [Functions](/platform/wemreference/sql-compatibility/functions.md)
- [Keywords](/platform/wemreference/sql-compatibility/keywords.md)
- [Operators](/platform/wemreference/sql-compatibility/operators.md)
- [WEMScript for Custom HTML](/platform/wemreference/wemscript-for-custom-html.md): The WEM-Specific script language in the Interaction Template Editor
- [WEM Widgets](/platform/wemreference/wem-widgets.md): An introduction to WEM Widgets and WEMscript, used to create widgets
- [WEM Widget Structure](/platform/wemreference/wem-widgets/wem-widget-structure.md): If you want to create your own custom widgets.
- [WEMScript for Widgets](/platform/wemreference/wem-widgets/wemscript-for-widgets.md): The WEM-Specific script language for WEM Widgets
- [Widget Editor](/platform/wemreference/wem-widgets/widget-editor.md)
- [Content Placeholder](/platform/wemreference/wem-widgets/content-placeholder.md): WEM Widgets Extension: Placeholder for content elements
- [Regression Test Framework](/platform/wemreference/regression-test-framework.md)
- [WEM Test Script](/platform/wemreference/regression-test-framework/wem-test-script.md): a.k.a. Flint-Script