...
Member filters provide the ability to filter the rows of a reference set, based on the value of specific fields in the reference set. These filters are specified inside double curly braces, and begin with the letter "M".
Member Field Filters
To apply a member filter to one or more reference sets, the fields of those reference sets are matched against specified criteria. Only reference set members whose field values match the given criteria will be included in the results.
...
Scg expression |
---|
Border | ridge |
---|
ShowFormat | block |
---|
|
^ 447562003 |ICD-10 complex map reference set| {{ M mapTarget = "J45" }} |
Alternatively, a wildcard search can be performed, to achieve similar results. For example, the expression constraint below will match on rows that have a mapTarget starting with "J45" followed by zero or more other characters (e.g. "J45.0", "J45.1",...,"J45.8", "J45.9")
Scg expression |
---|
Border | ridge |
---|
ShowFormat | block |
---|
|
^ 447562003 |ICD-10 complex map reference set| {{ M mapTarget = wild:"J45*" }} |
To achieve To ensure an exact string match is performed, a wildcard search (without an '*') is requiredcan be used. For example, the expression constraint below will match only match rows that have a mapTarget of "J45.9".
Scg expression |
---|
Border | ridge |
---|
ShowFormat | block |
---|
|
^ 447562003 |ICD-10 complex map reference set| {{ M mapTarget = wild:"J45.9" }} |
For more information on wildcard and word-prefix-any-order searching, please refer to 6.8 Description Filters.
Multiple field constraints can be applied within a reference set member filter. For example, the following expression constraint will return the referencedComponentId from the
Concept |
---|
t | 447562003 |ICD-10 complex map reference set| |
---|
|
rows, which have a mapGroup of "2", a mapPriority of "1" and a mapTarget of "J45.9".
...
For additional ways of specifying queries over the historical association reference sets, please refer to 6.11 History Supplements.
Module Filter
Module filters enable an expression constraint to match on only those rows of a reference set that belong to a specified module. Module filters use the keyword "moduleId" with a concept reference that is
Scg expression |
---|
|
< 900000000000443000 |Module| |
.
For example, the expression constraint below matches all members of the
Concept |
---|
t | 900000000000534007 |Module dependency reference set| |
---|
|
that belong to an Australian maintained module. Scg expression |
---|
Border | solid |
---|
ShowFormat | block |
---|
|
^ 900000000000534007 |Module dependency reference set| {{ M moduleId = << 32570231000036109 |Australian maintained module| }} |
Effective Time Filter
Effective time filters enable an expression constraint to match on only those rows of a reference set with an effectiveTime that matches the specified criteria.
For example, the following expression constraint matches all rows of the
Concept |
---|
t | 816080008 |International Patient Summary| |
---|
|
which have been updated since 31st July 2021 (inclusive). Note that the referencedComponentId is the only field returned. Scg expression |
---|
Border | solid |
---|
ShowFormat | block |
---|
|
^ 816080008 |International Patient Summary| {{ M effectiveTime >= "20210731" }} |
Active Filter
Active filters enable an expression constraint to match on only those members of a reference set with a matching active status. Reference set rows are either active (i.e. active = 1 or active = "true") or inactive (i.e. active = 0 or active = "false"). By default, only active members of a reference set are included in the substrate.
For example, the following expression constraints returns the inactive members of the
Concept |
---|
t | 816080008 |International Patient Summary| |
---|
|
.
Scg expression |
---|
Border | solid |
---|
ShowFormat | block |
---|
|
^ 816080008 |International Patient Summary| {{ M active = 0 }} |