1 of 9

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

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

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: 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 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 main page for Contains.