1 of 13

Concepts

ConceptId

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.

Returns a number that is internally used by wem to identify concept.

Returns Unknown if the parameter is unknown.

Syntax

ConceptId(concept)

ConceptId('tickets')=>Result: 382446

ConceptId(unknownconcept)=>Result: unknown

ConceptId( first(concept of [1482498: Colors] where concept:'SecondaryColor' = true) )=>Result: 113787

Parameters

Name

Type

Required

Description

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.

Returns the description of a concept. This description can be edited in the properties of the concept.

Returns Unknown if the parameter is unknown, or if the description property is empty.

Syntax

Description(concept)

Description('Images'.'Piano')=>Result: "Which instruments do you want us to break?"

Description(unknownconcept)=>Result: unknown

Parameters

Name

Type

Required

Description

FindConcepts

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.

Returns a concept set that contains all the concepts found with the given parameters.

Returns Unknown if one of the parameter values is unknown, or if the search parameters yield no result.

Syntax

FindConcepts(text, concept_set, include_synonyms)

FindConcepts(unknowntext, unknownconceptset, unknownboolean)=>Result: unknown

FindConcepts("not part of set", GetChildren('Devices'), false)=>Result: unknown

FindConcepts("screen", GetChildren('Devices'), true)=>Result: 'Monitor'

FindConcepts("screen", GetChildren('Devices'), false)=>Result: unknown

FindConcepts("Monitor", GetChildren('Devices'), false)=>Result: 'Monitor'

Parameters

Name

Type

Required

Description

GetAncestors

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.

Returns a Concept Set with all the parent concepts of a concept. The concept parameter is not included in the result.

An unknown value is returned if the concept has no parent or the given parameter is unknown.

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

Syntax

GetAncestors(concept)

GetAncestors(unknownconcept)=>Result: unknown

GetAncestors('Languages'.'Dutch')=>Result: Languages

GetAncestors('World regions'.'EMEA'.'CIS') =>Result: { 'World regions' , 'EMEA' } as a concept set

Parameters

Name

Type

Required

Description

GetChildren

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

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

Returns a concept set that contains the direct child concepts of a concept.

An unknown value is returned if the concept has no children or the given parameter is unknown.

The function includes all descendants (multiple levels).

Syntax

GetChildren(concept)

GetChildren('World regions'.'EMEA')=>Result: { MENA, CIS, DACH }

GetChildren('Color')=>Result: { Blue, Red, Yellow, Green, Orange, Purple, Amber, Magenta, Teal, Violet }

GetChildren('Color') where concept:'PrimaryColor' = true =>Result: { Blue, Red, Yellow }

GetChildren('Color'.'Green')=>Result: unknown

GetChildren(unknownconcept)=>Result: unknown

Parameters

Name

Type

Required

Description

GetDescendants

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.

Returns a concept set that contains all the descendant concepts of a concept. The concept parameter is not included.

An unknown value is returned if the concept has no descendants or the given parameter is unknown.

The GetChildren() function only returns the direct child concepts.

Syntax

GetDescendants(concept)

GetDescendants('World regions')=>Result: APAC, EMEA, MENA, CIS, DACH, LATAM, NA

GetDescendants('Color'.'Green') =>Result: unknown

GetDescendants(unknownconcept)=>Result: unknown

Parameters

Name

Type

Required

Description

GetParent

The GetParent() function returns the direct parent concept 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.

Returns the direct parent concept of a given concept.

An unknown value is returned if the concept has no parent or the given parameter is unknown.

The GetAncestors() function includes the entire parent chain from root to concept (excluding root and concept).

Syntax

GetParent(concept)

GetParent('Color'.'Violet')=>Result: Color

GetParent('World regions'.'EMEA'.'MENA') =>Result: EMEA

GetParent(unknownconcept)=>Result: unknown

Parameters

Name

Type

Required

Description

Intersection

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.

Returns a concept set with the concepts that occur in each concept set provided in the parameter list.

An unknownconceptset value is returned if any of the conceptsets in the list is unknown, or if there is no concept available in all sets in the parameterlist.

Syntax

Intersection( List(concept_set_1, concept_set_2, ...) )

Intersection( List([AllColors], 'Color'.'Purple') )=>Result: { Purple } (as a conceptset with one concept)

Intersection( List( [AllColors], {'Color'.'Amber', 'Color'.'Teal'}) )=>Result: { Amber, Teal }

Intersection( List( [AllColors], [EMEA-Regions]) )=>Result: unknownconceptset

Intersection( List(unknownconceptset, [AllColors]) )=>Result: unknownconceptset

Parameters

Name

Type

Required

Description

LocalName

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.

Returns a text that contains the local name of a concept.

An unknown value is returned if the concept is unknown.

Syntax

LocalName(concept)

LocalName('Misc'.'Data type'.'EntityReference')=>Result: "EntityReference"

LocalName('World regions'.'EMEA'.'CIS') =>Result: "CIS"

LocalName( GetParent('World regions'.'EMEA'.'CIS') ) =>Result: "EMEA"

LocalName(unknownconcept)=>Result: unknowntext

Parameters

Name

Type

Required

Description

Synonyms

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

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

Returns an array with text values that contain the synonyms of the given concept.

An unknown value is returned if the concept is unknown or there are no synonyms provided in the concept properties.

Syntax

Synonyms(concept)

Synonyms('Misc'.'GroupingLocalName')=>Result: "Groups, Group, Collection"

Split(ToString( Synonyms('Misc'.'GroupingLocalName') ), ", ")(2) =>Result: Group

Synonyms('concept-with-no-synonyms')=>Result: unknown

Synonyms(unknownconcept)=>Result: unknown

Parameters

Name

Type

Required

Description

ToConcept

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 FindConcepts or GetChildren.

Read general information about Concepts and Ontology

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

Returns the concept that is found with the given argument.

Returns Unknown if:

the parameter is unknown;
if no concept can be found for the provided parameter;
if there are multiple matches for the provided parameter (local name).

Syntax

ToConcept(localname)

ToConcept("dutch")=>Result: 'Languages'.'Dutch'

ToConcept("status")=>Result: unknown when there are multiple concepts with localname status in different parts of the ontology

ToConcept(unknownstring)=>Result: unknown

ToConcept(id)

ToConcept(1467668)=>Result: 'Languages'.'Dutch'

ToConcept(unknownnumber)=>Result: unknown

Parameters

Union

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 (+).

Read general information about Concepts and Ontology

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

Returns a new concept set with all concepts provided in the parameter list. This collection can contain concepts from different parents.

Returns Unknown if one of the parameter values is unknown.

Syntax

Union( List(concepts | concept_sets) )

Union( List('Colors'.'Orange', 'Colors'.'Red', 'Colors'.'Blue') ) =>Result: { orange, red, blue } as a new concept set

Union( [Products.Markets] of [Products] ) =>Result: a combination of only the Markets that are stored in multi-select field in Products, for example { 'APAC', 'EMEA', 'CIS', 'LATAM', 'NA' }. Using the [multi-select-field] of [list] results in a list of concept-sets, so the List() function is not necessary in this case.

Union( List(GetChildren('Color'), [AllDevices], 'Status'.'Assigned') ) =>Result: a combination of all color-children concepts, all Devices from conceptset and the Assigned status concept.

Similar results can be achieved with addition:

'Colors'.'Orange' + 'Colors'.'Red' + 'Colors'.'Blue'

List(GetChildren('Color') + [AllDevices] + 'Status'.'Assigned'

Parameters

Name

Type

Required

Description