Example Queries

Learn from these practical ECL examples

Products containing Paracetamol

Try it

Find all medicinal products that contain paracetamol as an active ingredient.

<< 763158003 |Medicinal product| :
  << 127489000 |Has active ingredient| = 
    << 387517004 |Paracetamol|

Oral Amoxicillin Products

Try it

Find medicinal products with amoxicillin in oral dose form.

< 763158003 |Medicinal product| :
  411116001 |Has dose form| = 
    << 385268001 |Oral dose form|,
  << 127489000 |Has active ingredient| = 
    << 372687004 |Amoxicillin|

Diabetes Disorders

Try it

Find all types of diabetes mellitus and related conditions.

<< 73211009 |Diabetes mellitus|

Lung Disorders with Edema

Try it

Find lung disorders that have edema as the morphology.

< 19829001 |Disorder of lung| :
  116676008 |Associated morphology| = 
    << 79654002 |Edema|

Injectable Products

Try it

Find products with injection or parenteral dose forms.

<< 763158003 |Medicinal product| :
  411116001 |Has dose form| = 
    << 385219001 |Injection dose form|

Products Causing Reactions

Try it

Find concepts where paracetamol is the causative agent.

*: 246075003 |Causative agent| = 
  387517004 |Paracetamol|

ECL Syntax Quick Reference

Self

Match only the specified concept

404684003 |Clinical finding|

Descendants

All subtypes of a concept

< 404684003 |Clinical finding|

Descendants or Self

Concept plus all its subtypes

<< 73211009 |Diabetes mellitus|

Children

Direct children only (one level)

<! 404684003 |Clinical finding|

Ancestors

All supertypes of a concept

> 40541001 |Acute pulmonary edema|

Parents

Direct parents only (one level)

>! 40541001 |Acute pulmonary edema|

Member Of

Concepts in a reference set

^ 700043003 |Example refset|

Any

Match any concept

*

Attribute Refinement

Filter by attribute value

< 404684003 |Clinical finding| :
  116676008 |Associated morphology| = 
    79654002 |Edema|

Multiple Attributes

Multiple conditions (AND)

< 404684003 |Clinical finding| :
  363698007 |Finding site| = << 39057004 |Pulmonary valve|,
  116676008 |Associated morphology| = << 415582006 |Stenosis|

Conjunction (AND)

Must match both constraints

< 19829001 |Disorder of lung| AND
< 301867009 |Edema of trunk|

Disjunction (OR)

Match either constraint

< 19829001 |Disorder of lung| OR
< 301867009 |Edema of trunk|
Copied to clipboard!