Expressions›

withoutClause

An anti-join inclusion clause that restricts the primary query to rows for which no row from the secondary source satisfies the such that condition. Equivalent to a semi-anti-join.

Examples

Exclude encounters with excluded procedures

from [Encounter: "Inpatient Encounter"] E
  without [Procedure: "Excluded Procedure"] P
    such that P.performed during E.period

Exclude patients with prior diagnosis

from [Condition: "Diabetes Mellitus"] C
  without [Condition: "Prior Exclusion"] X
    such that X.onset before C.onset

Railroad Diagram

100%

scroll to zoom · drag to pan · click green rules or blue tokens to navigate

EBNF

withoutClause
  : 'without' aliasedQuerySource 'such that' expression
  ;

Used In

queryInclusionClause