The IsPreview()function checks if the portal is being used in the Preview Runtime environment.

This function allows you to make certain features available only in the Preview environment. For example in a "Visible when" property of a navigation item, or even using a Decision Node in a flowchart to make a detour.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The ConceptId() function returns the internal id of a concept.

Read general information about Concepts and Ontology

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The First() function returns the first item in a list or concept set.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

First() and Last() on a database list use the RowID for standard sorting - so First([Name] of [Products]) will get the name-fieldvalue of the first item created, and Last([Name] of [Products]) will get the name-fieldvalue of the last item created.

You can limit/specify the resultlist using the WHERE options, and within that resultlist, the lowest or highest RowID will be returned.

In future we will add the [Order By] syntax to WEM Expressions, so you can specify the order yourself in the expression, and then the First and Last will use that sorting.

In some specific cases if you want the First/Last item based on another fieldvalue, like LastModified, you could use something like

The DayOfWeek() function returns the day of the week. Monday is day 1 and Sunday is day 7.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The Average() function calculates the average of a list of numbers, date times or duration.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The Union() function produces a concept set with all the concepts from a collection of concept sets and concepts (needs the List() function to combine literal sets and concepts).

Combining concepts and concept sets into a new concept set can also be achieved using addition (+).

This function is NOT SQL compatible. For more information about SQL compatibility, see our

The DatePart() function retrieves a part from a date. For example, the year, the month, the week, the day, the hour, the minutes or the seconds.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The UTCToday() returns the current date in UTC

WIKI:

This function is SQL compatible. For more information about SQL compatibility, see our .

The PortalId()function gets the id of the current portal.

This function can be used to enable or disable certain features for a specific portal.

This function is SQL compatible. For more information about SQL compatibility, see our .

The ProjectName() function gets the name of the current project.

This function is SQL compatible. For more information about SQL compatibility, see our .

The IpAddress()function gets the IP address of the client.

This function can be used to route users from a certain network to a specific page or a custom login process. It can also be used to track the (public) IP-addresses of your users. Please note that some countries have legislation about using and storing IP-addresses (GDPR).

WIKI: http://en.wikipedia.org/wiki/IP_address

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The NodeTrail() function returns the most recent flowchart nodes (to a max of 20 nodes) that the user passed in current flow.

This function can be used in debugging, allowing you to see the history of steps taken before a certain situation is reached. Every number divided by the "," can be used to search for in the flowchart tab, to find the corresponding node.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The UTCNow() returns the current date and time in UTC.

WIKI: https://en.wikipedia.org/wiki/Coordinated_Universal_Time

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The URLPath() function returns the URL path of the current page.

The URLPath can be configured in a Navigation Item when it is a deeplink. Combined with the hostname of the portal, the UrlPath provides a link that can be used as an address or link from outside (in e-mail for example) directly to the flowchart that is linked to the Navigation Item.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The PortalName()function gets the name of the current portal.

This function can be used to enable or disable certain features for a specific portal.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The IsStaging()function checks if the portal is being used in the Staging Runtime environment.

This function allows you to make certain features available only in the Staging environment. For example in a "Visible when" property of a navigation item, or even using a Decision Node in a flowchart to make a detour.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The ProjectVersion() function gets the latest publish timestamp the current project.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The IsLive()function checks if the portal is being used in the Live Runtime environment.

This function allows you to make certain features available only in the Live environment. For example in a "Visible when" property of a navigation item, or even using a Decision Node in a flowchart to make a detour.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

Returns the value of Pi with 10 decimals.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The LocalName() function returns the local name of a given concept.

Read general information about Concepts and Ontology

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The GetChildren() function returns all the child concepts of a concept.

Read general information about Concepts and Ontology

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The Today() function returns the current date.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The Count() function returns the number of items in a list or concept set.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The Synonyms() function returns the synonym text values of a concept.

Read general information about Concepts and Ontology

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The Intersection() function produces a concept set that contains the concepts that a part of all given concept sets in the parameters.

Read general information about Concepts and Ontology

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The DateOnly() function only returns the date part without the time part of a date.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The ApplicationId()function returns the Id of the application

The FromUnixTimestamp() function converts a unix timestamp to a date.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The Now() function returns the current date.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The Setting()function returns the text value of a project variable. Project variables are configured in the Project Configuration page.

This function in combination with the project variables allows you to have a single place to edit variables that are used in multiple parts of your application. In the example below a project variable named "Support e-mail" is added.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The ToUnixTimestamp() function converts a date to a unix timestamp.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The DateDiff() function calculates the difference between two dates. You can use the DateDiff for the difference in: year, month, week, day, hour, minute or second.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The MoveDate()function shifts a date by a given amount of a date unit.

This function is SQL compatible. For more information about SQL compatibility, see our .

The Max() function calculates the highest value of a list of numbers, datetimes or durations.

This function is SQL compatible. For more information about SQL compatibility, see our .

The TimeOfDay() function returns the duration that represents the fraction of the day that has elapsed since midnight.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The ToLocal() function converts a UTC date to a local date with the given timezone (TZ database name). You can find the time zones used in wem in the list of .

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The MimeType() function returns the type of a provided file, based on its extension and the first few bytes in the file.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

Checks whether the portal is viewed in (secure communication).

In you can activate [force https] to make your portal run in secure https-mode.

This function is SQL compatible. For more information about SQL compatibility, see our .

The IsFirstRequest()function checks if the server is handling the first request of the client.

The first request of a client is the first time a browser tab connects to any page in your application. All subsequent actions in that same browser tab will no longer be viewed as the first request as long as the session is active.

This function can be used for an action that you would only like to perform when a user opens your application for the first time.

This function is SQL compatible. For more information about SQL compatibility, see our

The FileSize() function returns the size of a file, in KB’s.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The Log10() function calculates the base-10 logarithm of a given number.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The Ceiling() function rounds a number up to an integral value (integer number without decimals) larger than or equal to the given number.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The CountryName() function returns the name of the country that belongs to the specified language parameter.

The language parameter is a specific language-code which is in the form en_US or nl_NL. (not a text with double quotes). The Expression Editor Functions Pane has a folder Localization where you can find the specific LanguageCodes.

The Exp() function calculates the e-number raised to the power n, where n is an number.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The ToUTC() function converts a local date with the given timezone (TZ database name) to a UTC date. You can find the time zones used in wem in the list of .

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The GetParent() function returns the direct parent concept of a given concept.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The NameOf() function returns the name of an item from the data model.

This function is SQL compatible. For more information about SQL compatibility, see our .

The Min() function calculates the lowest value of a list of numbers, datetimes or durations.

This function is SQL compatible. For more information about SQL compatibility, see our .

The FileName() function returns the name of a file.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

Generates a unique 256 bit AES key, to be used with the AES encryption and decryption functions.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The Hostname() function returns the domain name of the active portal of your published WEM project. For more information about the domain name visit https://en.wikipedia.org/wiki/Domain_name.

This function can be used to create links to (specific pages of) your application. For example a link in a reset password or create account e-mail (see syntax for an example). By using the hostname function you ensure that the generated link always points to the right portal in the right environment.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The Last() function returns the last item in a list or concept set.

For (persistent) lists it now also accepts a list as parameter - only to be used in Kubernetes Runtime 4.2 (not in Shared Europe, Shared APAC or any private runtime 4.1.xxx).

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Possible fault message in expression editor: Invalid call to a function: parameter mismatch at position(x,y): Last

This could mean that there is no field of list used, but only the (reference to a) list.

For Runtimes Shared EUR, Shared APAC and Private Clouds v4.1.xx, the Last function needs a field from list where filter construction, or if you only want to get the last row of a list, use RowId([list]) of [list] where [filter].

For Runtimes 4.2, the Last function now also accepts a List as parameter - no longer requiring a specific field.

First() and Last() on a database list use the RowID for standard sorting - so: First([Name] of [Products]) will get the name-fieldvalue of the first item created, and Last([Name] of [Products]) will get the name-fieldvalue of the last item created.

You can limit/specify the resultlist using the WHERE options, and within that resultlist, the lowest or highest RowID will be returned.

In future we will add the [Order By] syntax to WEM Expressions, so you can specify the order yourself in the expression, and then the First and Last will use that sorting.

In some specific cases if you want the First/Last item based on another fieldvalue, like LastModified, you could use something like

The CountryCode()function returns two-letter country code of a language parameter.

The language parameter is a specific language-code which is in the form en_US or nl_NL. (not a text with double quotes). The Expression Editor Functions Pane has a folder Localization where you can find the specific LanguageCodes.

This function is SQL compatible. For more information about SQL compatibility, see our .

The GetDescendants() function returns all descendant concepts of a concept.

Read general information about Concepts and Ontology

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The Cos() calculates the cosine of a given radian value.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The Description() function returns the description of a concept.

Read general information about Concepts and Ontology

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The IsNewRow() function returns a boolean value that indicates if the specified row is newly created and not yet saved to the database.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The Sqrt() function calculates the square root of a number.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The IsOnRow() function returns a yes/no value that indicates that the indicated list has a specific Row selected; this can be achieved for example by using a list node (go to row), loop node (going though multiple rows in a list) or clicking on a row in a datagrid. or - in case a reference-field is used with this function - the reference-field has a value and is indeed pointing to a specific row in the referenced list (achieved using an assignment node).

When a List is on a specific row, you can access the values of the fields in the list (to read or write values). If you try to read or write specific fields in a list, when there is no current row, you will get a fault message with something like "there is no current row". So, to be sure you can access fields of a specific item in a list and to avoid this fault situation, you can check this using the IsOnRow function.

The list-node action Reset Row Position will set the IsOnRow to false: there will be no specific row selected on the list. The assignment action Clear value on a reference-field will clear the reference so it will no longer point to a specific row - the IsOnRow will in that case also yield false.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The Abs() function takes the absolute value of a number.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The GetAncestors() function returns all the parents (ancestors) of a concept.

Read general information about Concepts and Ontology

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The PasswordStrength() function Calculates a numeric representation of the strength of a password from 0 (blank), 1 (very weak) up to 5 (very strong).

Combining different types of characters makes for stronger passwords, but a very long password of only lowercase characters (like a sentence) can also be strong.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The List() function creates a list-typed collection of the provided values so it can be used in other functions and features that work with a list. All values must be of the same type.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The Sin() function calculates the sine of a number given in radians.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The Distinct() function returns a list of unique values from a provided list of values. The list must contain only values of the same type, and they may be numbers, dates, concepts, texts, yes/no booleans.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The Password() function returns a text that contains a randomly generated strong password with a specified number of characters.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The Sum() function calculates the total value of a list of numbers or durations.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The ToConcept() function returns the concept with the given Local Name or Concept Id.

Be aware that using this function with a Local Name, this can only work if the local name used is unique in the total ontology collection. If there are more than one concept with the same local name that you are looking for, the ToConcept will not work because it searches through all of the Ontology and expects only 1 specific result to return as Concept.

For finding concepts when local name may not be unique and you want to search within a specific parent, we recommend using one of the other Concept Functions available, where you can search more specifically, like or .

The FileUrl() function returns the URL of a file.

Optionally - with the second parameter includeDomain set to true - it will return the URL including the full domain so it can be used externally as full absolute path.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The Random() generates a random number.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The Floor() function rounds down to the closest integral number (integer number without decimals) smaller than or equal to the given number.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The Log() function calculates the natural logarithm (base e) of a given number, or calculates the logarithm of a number by specified base.

Read .

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The CreateJsonWebTokenH256() function returns the HMAC-SHA256 encoded JWT () for given payload (json value) and secret (password text), using the standard JWT header {alg=HS256 and typ=JWT} or a custom header.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

JWT tokens are used in authentication (Single Sign On) contexts, and designed to be compact, URL-safe and secure. Sites like Google or Zoom use JWT. They may provide information on how to work with their JWT for sign-on (with code examples for PHP, Python or C#), and if it supports the standard implementation, you can use this WEM Function to create the proper JWT - just provide the proper values for the payload and the secret. For the extensive standard information behind standard JWT, read the wiki pages.

The Date() function accepts numeric values for each part of a date, optionally with time, and returns it as a datetime value.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The RowId() function returns the ID of the current row of a list.

Any database list also has a numeric [ID] field which holds the numeric primary key value for each row and gets automatically incremented on each add new row action. When you use that ID field in your expressions, you will see it in the form [12345: ID], which does not make it immediately clear which field (or rather, which list) you are pointing to. Other fields use the Technical Name in expressions, which helps to understand where they are coming from. When using the RowId(list) function in expressions, you will see immediately to which list you are referring, so this makes it far more usable.

The FindConcepts() function searches concepts by text and/or synonyms within an indicated set.

Read general information about Concepts and Ontology

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The Pow() function calculates a number to the power of another number.

The operator ^ can also be used to do power-calculation.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The AesEncrypt() function generates a base64 encoded ciphertext based on the given plaintext, key and initialization vector.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

The Md5() function hashes one or more text strings into one hexadecimal text value which is hashed using the MD5 algorithm.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Hashed values cannot be decoded, usually you check an incoming value against a known value that you hash yourself and check if both values are identical, to verify correctness without knowing the actual value.

The Distance() function returns the geographical distance (in kilometers - as the crow flies) between two points of (latitude,longitude).

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The ToNumber() converts a value to a number.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

With Modeler v4.4 and Runtimes v5 (August 2025), the ToNumber function got a new overload that accepts a duration and a duration_unit. Older runtimes will show "invalid expression" when this overload is used.

The AesDecrypt() function decrypts a base64 encoded ciphertext to plaintext, using the given key and initialization vector.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The Round() function rounds a number.

Rounding a number can be done according to different strategies when it comes to the mid-point cases (like x.5).

WEM supports the Banker's Rounding strategy as default option because of its statistical superiority and standard use in financial and statistical operations.

From Runtime 4.2 an optional strategy parameter is added to this function. It allows 2 keywords, ToEven (which is default) and

The HmacSha256() function calculates a on provided message using the SHA256 hash function and a key/secret, and returns the calculated MAC as a hexadecimal text string.

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

Hashed values cannot be decoded, usually you check an incoming value against a known value that you hash yourself and check if both values are identical, to verify correctness without knowing the actual value.

The PBKDF2() function creates a secure password hash for a password and a salt by using the PBKDF2 hashing algorithm with 1000 iterations.

WIKI:

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

Hashed values cannot be decoded, usually you check an incoming value against a known value that you hash yourself and check if both values are identical, to verify correctness without knowing the actual value.

The Totp() function calculates a time-based one-time password based on the given secret and given UTC time.

WIKI:

MyWEM Forum:

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

The Sha256() function hashes a specified text string with SHA256, and returns a hexadecimal text string. This hash function is preferred to SHA-1, being more secure.

WIKI:

This function is NOT SQL compatible. For more information about SQL compatibility, see our .

Hashed values cannot be decoded, usually you check an incoming value against a known value that you hash yourself and check if both values are identical, to verify correctness without knowing the actual value.

The Sha1() function hashes a specified text string with SHA1, and returns a hexadecimal text string.

SHA-1 is not considered secure, but some older systems still use this encryption. WEM supports this ONLY at your own risk, and ONLY to be used to integrate with other systems that provide no other way.

WIKI:

This function is NOT SQL compatible. For more information about SQL compatibility, see our