SQL Practical Guide

Search

SNOMED CT Document Library

    Loading...

Page tree

Versions Compared

Old Version 5

changes.mady.by.user Jon Zammit

Saved on

compared with

New Version 6

changes.mady.by.user David Markwell

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note
titleNotes
  1. The expression constraints supported do not cover the full ECL specification but are restricted as described below.
  2. This procedure will only run in MySQL version 8.0 or later. It uses some function which are not available in earlier versions (including the widely used MySQL version 5.7).



Caption label
CapIdecl-query
CapTypeExample
Example Use of eclQuery Procedure



SQL Call to Procedure

call snap_eclQuery(p_ecl);

ParameterDescriptionData typeExamples

p_ecl

The ECL query texttext

(< 19829001 |disorder of lung|) OR (< 301867009 |edema of trunk|)

'(< 19829001 |disorder of lung|) MINUS (< 301867009 |edema of trunk|)'

'>> 40541001 |Acute pulmonary edema|'

'>39057004 |pulmonary valve|'

'>!39057004 |pulmonary valve|'

Example Procedure Call
Code Block
languagesql
themeConfluence
call snap_eclQuery('< 19829001 |disorder of lung|:116676008 |Associated morphology| = 40829002 |Acute edema|');

Result

conceptIdterm
10519008Acute pulmonary oedema due to fumes AND/OR vapours
40541001Acute pulmonary oedema
61233003Silo-fillers' disease
233706004Drug-induced acute pulmonary oedema
233709006Toxic pulmonary oedema
233710001Chemical-induced pulmonary oedema
233711002Oxygen-induced pulmonary oedema
360371003Acute cardiac pulmonary oedema
10674871000119105Pulmonary oedema caused by chemical fumes

Expression Constraint Feature Support and Limitations

...

ECL Operator

Summary

Example

Symbol

Name

<

Descendant of

The set of all subtypes of the given concept

< 404684003 |Clinical finding|

<<

Descendant or self of

The set of all subtypes of the given concept plus the concept itself

<< 73211009 |Diabetes mellitus|

>

Ancestor of

The set of all supertypes of the given concept

> 40541001 |Acute pulmonary edema|

>>

Ancestor or self of

The set of all supertypes of the given concept plus the concept itself

>> 40541001 |Acute pulmonary edema|

<!

Child of

The set of all children of the given concept

<! 195967001 |Asthma|

>!Parent ofThe set of all parents of the given concept>! 195967001 |Asthma|

^

Member of

The set of referenced components in the given reference set

^ 733990004 |Nursing activities reference set|

*

Any

Any concept in the given SNOMED CT edition

*

:

Refinement

Only those concepts whose defining relationships match the given attribute value pairs

< 404684003 |clinical finding|: 116676008 |associated morphology| = *

AND

Conjunction

Only those concepts in both sets

(< 19829001 |disorder of lung|) AND (< 301867009 |edema of trunk|)

OR

Disjunction

Any concept that belongs to either set

(< 19829001 |disorder of lung|) OR (< 301867009 |edema of trunk|)

MINUS

Exclusion

Concepts in the first set that do not belong to the second set

(< 19829001 |disorder of lung|) MINUS (< 301867009 |edema of trunk|)

...