FQL is a query language that allows you to retrieve, filter and project data from any data source containing FHIR Resources. It brings the power of three existing languages together: SQL, JSON and FhirPath. It allows you to create tables and is useful for gaining insight and perform quality control.
Filters
Code | Description | Operator | Value |
concept | Filter that includes concepts based on their logical definition. e.g. [concept] [is-a] [x] - include all concepts with an is-a relationship to concept x, or [concept] [in] [x]- include all concepts in the reference set identified by concept x | IsAIn | A SNOMED CT code |
expression | The result of the filter is the result of executing the given SNOMED CT Expression Constraint | Equal | A SNOMED CT ECL expression (see http://snomed.org/ecl) |
expressions | Whether post-coordinated expressions are included in the value set | Equal | true or false |
This code system http://snomed.info/sct defines many codes, but they are not represented here
Properties
Code | URL | Description | Type |
inactive | http://snomed.info/field/Concept.active | Whether the code is active or not (defaults to false). Not the same as deprecated | Boolean |
definitionStatusId | http://snomed.info/field/Concept.definitionStatusId | Either of the codes that are descendants of 900000000000444006 | Code |
parent | http://.........? | A SNOMED CT concept id that has the target of a direct is-a relationship from the concept | Code |
child | http://.........? | A SNOMED CT concept id that has a direct is-a relationship to the concept | Code |
moduleId | http://snomed.info/field/Concept.moduleId | The SNOMED CT concept id of the module that the concept belongs to. | Code |
normalForm | http://.........? | Generated Normal form expression for the provided code or expression, with terms | String |
normalFormTerse | http://.........? | Generated Normal form expression for the provided code or expression, conceptIds only | String |
Due to | http://snomed.info/id/42752001 | Code | |
Associated with | http://snomed.info/id/47429007 | Code | |
Associated morphology | http://snomed.info/id/116676008 | Code | |
Has specimen | http://snomed.info/id/116686009 | Code | |
Specimen source morphology | http://snomed.info/id/118168003 | Code | |
Specimen source topography | http://snomed.info/id/118169006 | Code | |
Specimen source identity | http://snomed.info/id/118170007 | Code | |
Specimen procedure | http://snomed.info/id/118171006 | Code | |
Part of | http://snomed.info/id/123005000 | Code | |
Has active ingredient | http://snomed.info/id/127489000 | Code | |
Subject of information | http://snomed.info/id/131195008 | Code | |
Causative agent | http://snomed.info/id/246075003 | Code | |
Associated finding | http://snomed.info/id/246090004 | Code | |
Component | http://snomed.info/id/246093002 | Code | |
Severity | http://snomed.info/id/246112005 | Code | |
Occurrence | http://snomed.info/id/246454002 | Code | |
Episodicity | http://snomed.info/id/246456000 | Code | |
Technique | http://snomed.info/id/246501002 | Code | |
Revision status | http://snomed.info/id/246513007 | Code | |
Units | http://snomed.info/id/246514001 | Code | |
After | http://snomed.info/id/255234002 | Code | |
Access | http://snomed.info/id/260507000 | Code | |
Method | http://snomed.info/id/260686004 | Code | |
Priority | http://snomed.info/id/260870009 | Code | |
Clinical course | http://snomed.info/id/263502005 | Code | |
Laterality | http://snomed.info/id/272741003 | Code | |
Associated procedure | http://snomed.info/id/363589002 | Code | |
Finding site | http://snomed.info/id/363698007 | Code | |
Laterality | http://snomed.info/id/363699004 | Code | |
Direct morphology | http://snomed.info/id/363700003 | Code | |
Direct substance | http://snomed.info/id/363701004 | Code | |
Has focus | http://snomed.info/id/363702006 | Code | |
Has intent | http://snomed.info/id/363703001 | Code | |
Procedure site | http://snomed.info/id/363704007 | Code | |
Has definitional manifestation | http://snomed.info/id/363705008 | Code | |
Indirect morphology | http://snomed.info/id/363709002 | Code | |
Indirect device | http://snomed.info/id/363710007 | Code | |
Has interpretation | http://snomed.info/id/363713009 | Code | |
Interprets | http://snomed.info/id/363714003 | Code | |
Measurement method | http://snomed.info/id/370129005 | Code | |
Property | http://snomed.info/id/370130000 | Code | |
Recipient category | http://snomed.info/id/370131001 | Code | |
Scale type | http://snomed.info/id/370132008 | Code | |
Specimen substance | http://snomed.info/id/370133003 | Code | |
Time aspect | http://snomed.info/id/370134009 | Code | |
Pathological process | http://snomed.info/id/370135005 | Code | |
Procedure site - Direct | http://snomed.info/id/405813007 | Code | |
Procedure site - Indirect | http://snomed.info/id/405814001 | Code | |
Procedure device | http://snomed.info/id/405815000 | Code | |
Procedure morphology | http://snomed.info/id/405816004 | Code | |
Finding context | http://snomed.info/id/408729009 | Code | |
Procedure context | http://snomed.info/id/408730004 | Code | |
Temporal context | http://snomed.info/id/408731000 | Code | |
Subject relationship context | http://snomed.info/id/408732007 | Code | |
Route of administration | http://snomed.info/id/410675002 | Code | |
Has dose form | http://snomed.info/id/411116001 | Code | |
Finding method | http://snomed.info/id/418775008 | Code | |
Finding informer | http://snomed.info/id/419066007 | Code | |
Using device | http://snomed.info/id/424226004 | Code | |
Using energy | http://snomed.info/id/424244007 | Code | |
Using substance | http://snomed.info/id/424361007 | Code | |
Surgical approach | http://snomed.info/id/424876005 | Code | |
Using access device | http://snomed.info/id/425391005 | Code | |
Role group | http://snomed.info/id/609096000 | Code | |
Property type | http://snomed.info/id/704318007 | Code | |
Inheres in | http://snomed.info/id/704319004 | Code | |
Towards | http://snomed.info/id/704320005 | Code | |
Characterizes | http://snomed.info/id/704321009 | Code | |
Process agent | http://snomed.info/id/704322002 | Code | |
Process duration | http://snomed.info/id/704323007 | Code | |
Process output | http://snomed.info/id/704324001 | Code | |
Relative to | http://snomed.info/id/704325000 | Code | |
Precondition | http://snomed.info/id/704326004 | Code | |
Direct site | http://snomed.info/id/704327008 | Code | |
Specified by | http://snomed.info/id/704346009 | Code | |
Observes | http://snomed.info/id/704347000 | Code | |
Is about | http://snomed.info/id/704647008 | Code |