Query Language Examples
Filter
Example query
Returns concepts...
active
*{{active = false}},* Description.active = true,term = match : "O/E"
Returns inactive concepts that have at least one active description that contains the term O/E
description.active
*{{Description.active = false,term = match : "NOS"}}
Returns concepts that have at least one inactive description that contains the term NOS
typeID
<<128927009|Procedure by method|{{term = match : "incision", typeId = <<900000000000013009|Synonym|}}
Returns concepts that have at least one synonym type description that contains the term incision
. So this query does not return the concept 118630004|Division|
which has incision
in its Definition type description only.
languageRefSetId
*{{term = match : "Haemorrhage", languageRefSetId = 900000000000509007|US English|}}
Returns concepts that have at least one description that contains the term Haemorrhage
and that description is referenced in the US English Language Reference Set. So this query does not return the concept 50960005| Hemorrhage (morphologic abnormality)
since it doesn't have any description referenced in the US English Language Reference Set that contains the term Haemorrhage
acceptableIn
< 404684003|Clinical finding|: 363698007|Finding site|= << 5665001|Retinal structure|{{acceptableIn = 900000000000509007|US English|,(term = match : "color" OR term = match : "colour")}}
Returns concepts that have at least one description that contains the term color
or colour
, and that description acceptable in the US English Language Reference Set.
preferredIn
< 404684003|Clinical finding| : 363698007|Finding site|= << 5665001|Retinal structure|{{preferredIn = 900000000000509007|US English|,(term = match : "color" OR term = match : "colour")}}
Returns concepts that have at least one description that contains the term color
or colour
, and that description preferred in the US English language reference set.
term = regex :
*{{term = regex : ".*
sorbi*.
"}}
Returns concepts that have at least one description that contains the term sorbi
at any part of a word. So the query returns the concept 19839007|Sorbitol (substance)|
and 386853004|Isosorbide (substance)|
as well.
term = match :
*{{term = match : "
sorbi
"}}
Returns concepts that have at least one description that contains a word starting with the sorbi
. So the query returns the concept 19839007|Sorbitol (substance)|
but does not return 386853004|Isosorbide (substance)|
term = exact :
*{{term = exact : "
sorbitol
"}}
Returns concepts that have at least one descriptions that contain the exact phrase sorbitol
.