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 the root to limit it to a parent.

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(localname, rootConcept)

ToConcept("Toyota",'Cars'.'Brand') =>Result: 'Cars'.'Brand'.'Toyota'

ToConcept("Toyota",unknownstring) =>Result: unknown

ToConcept(id)

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

ToConcept(unknownnumber) =>Result: unknown

Parameters

Name	Type	Required	Description
localname	text	☑️	text that is used to search the local name of a concept
id	numeric	☑️	number that is used to search concept by Concept Id