1 of 6

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 documentation.

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*/

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 documentation.

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

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.

All

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

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*/

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'.