1 of 39

Keywords

Contains

The Contains keyword can be used on either Texts, Concept Sets or Lists.

It checks if a text, a concept set or a list contains a value (of corresponding type).

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

Returns a Yes/No value that indicates if the searched item is indeed part of the source being searched.

Text functions are not case-sensitive and ignore diacritics (accents).

text contains text

"With tangerine trees and marmalade skies" Contains "marmalade"=> Yes

concept_set contains concept_b

{ 'PowerUser', 'Administrator' } Contains 'Administrator'=> Yes

concept_set contains concept_set

{'User', 'PowerUser', 'Admin' } contains { 'User', 'Admin' }=> Yes

{'PowerUser', 'Admin' } contains { 'User', 'PowerUser' }=> No (the second set is not contained entirely within the first set, although there is overlap - which is a different keyword/function)

list contains item

list(1, 2, 3) contains 2=> Yes

list("A", "B", "C") contains "B"=> Yes

Concepts

Ancestor of

The Ancestor Of keyword checks if a concept is the ancestor of another concept.

WIKI: https://en.wikipedia.org/wiki/Tree_(data_structure)#Terminology

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

Returns a Yes/No value that indicates if concept_a is an ancestor of concept_b.

concept_a ancestor of concept_b

'Europe' ancestor of 'Europe'.'the Netherlands'.'Amsterdam'=> Yes.

Child of

The Child Of keyword checks if a concept is a child of another concept.

WIKI:

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

Returns a Yes/No value that indicates if concept_a is an child of concept_b.

concept_a Child Of concept_b

'Europe'.'Amsterdam' Child Of 'Europe'=> Yes.

Concept

The Concept keyword can be used to get a handle to a concept in a set while the set is being iterated. It can be used in a loop, a repeater or datagrid based on a concept-set as label within the repeater, or in where-filter expressions on a concept-set.

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

Points to a (viariable) concept within a set to use as a handle while iterating through a set of concepts, so a certain action or check can be performed on each concept within the iteration.

Concept

GetChildren('Color') WHERE concept:'PrimaryColor' = true => all children of the Color concept that have a property PrimaryColor set to true. The concept-keyword is used as a handle to check - while going through the Children of Color - each concept for its PrimaryColor property.

Descendant of

The Descendant Of keyword checks if a concept is a descendant of another concept.

WIKI:

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

Returns a Yes/No value that indicates if concept_a is a descendant of concept_b.

concept_a Descendant Of concept_b

'Europe'.'the Netherlands'.'Amsterdam' Descendant Of 'Asia'=> No

Overlaps

The Overlaps keyword checks 2 sets of concepts to see if at least one concept is available in both sets.

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

Returns a Yes/No value that indicates if at least one concept is part of both sets in the comparison.

concept_set_a Overlaps concept_set_b

{ 'Orange', 'Blue' } Overlaps { 'Blue, 'Red', 'Orange' }=> Yes

{ 'Orange', 'Yellow' } Overlaps { 'Blue, 'Red' }=> No

Range of

The Range Of keyword returns all allowed concepts of a concept or concept-set based on the field definition (root concept, depth and type restriction).

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

Returns a concept set that contains all the allowed concepts for a specified single-select or multi-select-field.

Range Of concept

Range Of [single-select-field] => Returns all concepts of the Single Select Field (concept) based on its Root Concept, the indicated Depth (all descendants or only the Direct Children) and -optionally- the Concept-Type-restriction

Range Of concept_set

Range Of [multi-select-field] => Returns all concepts of the Multi Select Field (concept-set) based on its Root Concept, the indicated Depth (all descendants or only the Direct Children) and -optionally- the Concept-Type-restriction

Parent of

The Parent Of keyword checks if a concept is the parent of another concept.

WIKI:

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

Returns a Yes/No value that indicates if concept_a is the parent of concept_b.

concept_a Parent Of concept_b

'Europe' Parent Of 'Europe'.'the Netherlands'=> Yes

'Europe' Parent Of 'Europe'.'the Netherlands'.'Amsterdam'=> No

Contains

The Contains Keyword is a special one: it can be used on Texts, on Concept Sets and on Lists.

Check the .

Environment

ApplicationRoot

The ApplicationRoot keyword is used to retrieve a text value that contains the URL root-path of the portal.

Mainly useful for the preview as that includes the portal-id in the url.

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

Returns a text value containing the root-path of the application (excludes the hostname).

In Preview, it will yield the portal-id like "/{portal-id}" In Staging/Live runtimes, it will yield an empty string.

Combined with the function HostName() you can create a deeplink to a certain navigation item by its Path Name that will work in Preview (having the portal-id) as well as in Staging and Live

Syntax

ApplicationRoot

In Preview, your application will show https://preview.wem.io/{portal-id}?sv={session} ApplicationRoot => "/123456" where 123456 is your portal id.

hostname() + applicationroot + "/path-to-navigationitem" => "preview.wem.io/123456/path-to-navigationitem" on Preview => "portalname.staging.wem.io/path-to-navigationitem" on Staging => "portalname.live.wem.io/path-to-navigationitem" on Live

Platform

A keyword that retrieves a text value that contains the type of platform the application is running on. The possible values are: "web", "ios" and "android".

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

A web portal running in a browser returns "web". An app running on Android returns "android". An app running on iOS returns "ios".

Syntax

Platform

Platform => "web" in browser running your portal; => "android" in native app running on Android; => "ios" in native app running on iOS.

Lists

In

The IN keyword checks if a list or concept set contains a specific value.

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

Returns a Yes/No value that indicates if a list or a concept_set contains a value.

value IN value_list

"Wallet" IN ([Products.Name] of [Products]) => Yes: if [Products] has a product with a name that is wallet.

value_list IN value_list

List("Wallet", "Moneyclip") IN ([Products.Name] of [Products])=> Yes: if [Products] has products with a name that is wallet and one that is moneyclip. => No: if only one of the names are in [Products]

concept IN concept_set

'Role'.'Admin' IN { 'Role'.'PowerUser', 'Role'.'Admin' } => Yes

concept_set IN concept_set

{'Lang'.'nl-NL'} IN {'Lang'.'nl-NL','Lang'.'en-US'}=> Yes

{'Lang'.'de-DE', 'Lang'.'nl-NL'} IN {'Lang'.'nl-NL','Lang'.'en-US'}=> No: the whole set must be contained to return true.

Of

The OF keyword selects values from a list or concept set.

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

Returns an array of values.

expression OF list

([Products.Name] OF [Products])=> list of product names.

First([Products.Name] OF [Products])=> the Name of the first product in the Productlist

expression OF concept_set

concept:'ImageFile' of getchildren('Images') => the Image File Properties (in this case, the filenames as collection) of the children-concepts within 'Images'.

Where

The WHERE keyword filters a list or concept set.

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

Returns a filtered list or concept set.

list where condition

[Products.Name] of [Products] WHERE [Products.Price] > 100=> the names of all products that have a price higher than 100.

concept_set where condition

GetChildren('Color') WHERE concept:'PrimaryColor' = true => all color concepts from the Color collection that have the PrimaryColor property set to true.

Contains

The Contains Keyword is a special one: it can be used on Texts, on Concept Sets and on Lists.

Check the main page for Contains.

All

The ALL keyword is used to access all entities in nested entities, bypassing the parent-rows.

For example, you have the entities [Shop] and [Shop.Products] where [Shop.Products] is the nested entity. When you use Count([Shop.Products]), you’ll get number of products from the current shop only. If instead you want to count all products from all shops, you can write:

Count(ALL [Shop.Products])

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

Returns all entities of a given nested entity without limiting by active parent row.

all[entity]

First( ALL [Shop.Products] 
    where [Shop.Products.ProductCode] = "X-00014-1297"
)
/* searches all products in all shops and returns the first product that has a specified product code */

List([Shop] 
    where RowId([Shop]) in 
        (
        RowId([Shop]) of ALL [Shop.Products] 
        where [Shop.Products.Price] >= 20 
            and [Shop.Products.Price] <= 30
        )
)
/* returns all shops that have a product in the price range between 20 and 30*/

Logic

Keywords to use in logical expressions.

And

The AND keyword is used to combine two boolean conditions where both conditions must be true to yield a positive result.

This is the Conjunction within the boolean logical operations.

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

Returns a Yes/No value that indicates if both conditions evaluate to true.

conditionANDcondition

true AND false=> false

false AND true=> false

true AND true=> true

false AND false=> false

Not

The NOT keyword inverses (negates) a condition.

This is the Negation within the boolean logical operations.

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

Returns the inversed condition.

If the condition evaluates to unknown, the inverse (NOT unknown) is also unknown.

NOT condition

NOT false => true

NOT true => false

Or

The ORkeyword is used to combine two boolean conditions and will yield true if at least one condition evaluates to true.

This is the Disjunction within the boolean logical operations.

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

Returns a Yes/No value that indicates if at least one condition evaluates to true.

condition OR condition

true OR false=> true

false OR true=> true

true OR true=> true

false OR false=> false

Choose

The choose construction can be used to check a multitude of conditions and return the expression that is part of the first condition that evaluates to be true.

The full construction should be created as displayed in the syntax, starting with choose, ending with a default expression and the end keyword, and having 1 or more when ... then ... expressions in between.

The Choose construct in WEM is comparable to Case or Switch statements in some programming languages. See wikipedia.

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

Returns the value after the then of the first condition that returns true.

If all conditions return false, then the value after default is returned.

Don't forget the end keyword.

All values after each then and default keyword must be of the same type to be returned.

Syntax

/*basic syntax : */
choose
    when boolean_condition1 then value1
    when boolean_condition2 then value2
    when boolean_condition3 then value3
    when boolean_condition4 then value4
    when boolean_condition5 then value5
    default value
end

/*Example: */
choose
    when DayOfWeek ([Webshop.Orders.OrderDate]) = 1 Then "Monday"
    when DayOfWeek ([Webshop.Orders.OrderDate]) = 2 Then "Tuesday"
    when DayOfWeek ([Webshop.Orders.OrderDate]) = 3 Then "Wednesday"
    when DayOfWeek ([Webshop.Orders.OrderDate]) = 4 Then "Thursday"
    when DayOfWeek ([Webshop.Orders.OrderDate]) = 5 Then "Friday"
    when DayOfWeek ([Webshop.Orders.OrderDate]) = 6 Then "Saturday"
    when DayOfWeek ([Webshop.Orders.OrderDate]) = 7 Then "Sunday"
    default "Day of the week"
end

If Then Else

The If - Then - Else construct can be used to make conditional parts in an expression.

Constructs can be "nested", just as long as each "nesting" has a block of matching If, Then and Else.

See wikipedia for more info on this construct.

The Choose construct can be used as an alternative when multiple conditions need to be checked: in many cases the Choose construct will be easier to read and understand.

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

Returns the value after the Then if the condition in the If statement returns true. If the condition returns false, then the value after Else is returned.

Syntax

/* basic construction */
IF boolean_condition 
THEN value
ELSE value

/* extended construction */
IF boolean_condition THEN value
ELSE if boolean_condition THEN value
ELSE if boolean_condition THEN value
ELSE if boolean_condition THEN value
ELSE value

/* Examples: */
IF DayOfWeek ([Webshop.Orders.OrderDate]) = 1 
THEN "Monday"
ELSE "Not monday"

IF DayOfWeek ([Webshop.Orders.OrderDate]) = 2 
    THEN "Tuesday"
ELSE IF DayOfWeek ([Webshop.Orders.OrderDate]) = 3 
    THEN "Wednesday"
ELSE IF DayOfWeek ([Webshop.Orders.OrderDate]) = 4 
    THEN "Thursday"
ELSE IF DayOfWeek ([Webshop.Orders.OrderDate]) = 5 
    THEN "Friday"
ELSE IF DayOfWeek ([Webshop.Orders.OrderDate]) = 6 
    THEN "Saturday"
ELSE IF DayOfWeek ([Webshop.Orders.OrderDate]) = 7 
    THEN "Sunday"
ELSE "Monday"

Mobile

These keywords are only available in Native Mobile Apps projects

BatteryLife

Only available in Native Mobile Apps projects

The BatteryLife keyword can be used in Native Mobile projects to check and display the remaining battery life in percentage in a label. It yields a numeric value between 0 and 100.

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

Returns a Numeric value between 0 and 100, representing the percentage of available battery life of the mobile device.

BuildVersion

Only available in Native Mobile Apps projects

The BuildVersion keyword can be used in Native Mobile projects to check and display the Build Version information of the App as set in its app/portal-settings.

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

Returns a Text value, showing the Build Version as it is defined in the App Settings. Example: "1.0.0"

ConnectivityTypes

The ConnectivityTypes keyword can be used to check and display the available connection types which are supported by the client device.

This applies to any device (Ethernet typically for laptop/desktop browsers).

If you want a certain feature to be available on mobile devices only when they are on mobile data and not on Wi-Fi, you can use the Syntax example stated below.

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

Returns an Array of text value, showing the available connection types.

Possible values are: "wifi", "mobile" and "ethernet".

Example for any connectivity

// example for any connectivity:
ConnectivityTypes contains "wifi"
or
ConnectivityTypes contains "mobile"
or
ConnectivityTypes contains "ethernet"

Example for Native Mobile Device only on Mobile Data - not Wi-Fi

// example for any connectivity:
ConnectivityTypes contains "mobile"
and
NOT(ConnectivityTypes contains "wifi")

DeviceId

Only available in Native Mobile Apps projects

The DeviceId keyword can be used in Native Mobile projects to display the unique Device ID of the mobile device.

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

Returns a Text value with the unique identifier of the mobile device.

DeviceName

Only available in Native Mobile Apps projects

The DeviceName keyword can be used in Native Mobile projects to display the make and model information of the mobile device.

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

Returns a Text value with the make and model of the mobile device.

IsDevelopmentBuild

Only available in Native Mobile Apps projects

The IsDevelopmentBuild keyword can be used in Native Mobile projects to check if the current build is the Development Build from the Modeler.

The counterpart is the IsDistributionBuild.

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

Returns a Boolean / YesNo value:

True/Yes if the app is installed using the Development Build. False/No if the app is not running the Development Build.

IsDistributionBuild

Only available in Native Mobile Apps projects

The IsDistributionBuild keyword can be used in Native Mobile projects to check if the current build is the Distribution Build from the Modeler, which can be used for distribution via public App Stores.

The counterpart is IsDevelopmentBuild.

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

Returns a Boolean / YesNo value:

True/Yes if the app is installed using the Distribution Build. False/No if the app is not running the Distribution Build.

Text

Contains

The Contains Keyword is a special one: it can be used on Texts, on Concept Sets and on Lists.

Check the main page for Contains.

Ends with

The ends with keyword checks if a text ends with another text.

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

Returns a Yes/No value

This check is not case-sensitive and ignores diacritics (accents).

text_a ends withtext_b

"Text contains subtext" ends with "contains"=> false

"Text contains subtext" ends with "tëXT"=> true

"Text contains subtext" ends with unknowntext=> true

unknowntext ends with unknowntext=> true

unknowntext ends with "some text"=> false

NewLine

A keyword to indicate a new line character (i.e. "\n" or ).

When concatenating strings, you can use the newline keyword to separate the parts into lines. This only works when using standard texts (not rich texts) and display as text (not display as HTML). In the Rich Text / DIsplay HTML situation, you need to use the html-elements <p></p>, <div></div> or plainly <br/> to put texts in different lines.

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

Syntax

Newline

"first line" + newline + "second line" => "first line second line"

Starts with

The starts with keyword checks if a text starts with another text.

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

Returns a Yes/No value

This check is not case-sensitive and ignores diacritics (accents).

text_a starts with text_b

"Text contains subtext" starts with "contains"=> false

"Text contains subtext" starts with "tëXT"=> true

"Text contains subtext" starts with unknowntext=> true

unknowntext starts with unknowntext=> true

unknowntext starts with "some text"=> false