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.
<MedicationRequest xmlns="http://hl7.org/fhir"> <id value="14625" /> <meta> <profile value="http://interopsante.org/fhir/StructureDefinition/FrInpatientMedicationRequest" /> </meta> <contained> <Medication> <id value="med-51" /> <meta> <profile value="http://interopsante.org/fhir/StructureDefinition/FrMedicationUcd" /> </meta> <code> <coding> <system value="http://phast.fr/fhir/ValueSet/Pharmacy/CIOdc/SIPh-CIO_UCD" /> <code value="3400893936047" /> <display value="CODOLIPRANE 500 mg/30 mg, cpr" /> </coding> <text value="CODOLIPRANE 500 mg/30 mg, cpr" /> </code> <form> <coding> <system value="http://snomed.info/sct" /> <code value="421026006" /> <display value="comprimé oral" /> </coding> <text value="comprimé" /> </form> <ingredient> <itemCodeableConcept> <coding> <system value="http://snomed.info/sct" /> <code value="387517004" /> <display value="paracétamol" /> </coding> <text value="PARACETAMOL" /> </itemCodeableConcept> <isActive value="true" /> <strength> <numerator> <value value="500" /> <unit value="mg" /> <system value="http://unitsofmeasure.org" /> <code value="mg" /> </numerator> <denominator> <value value="1" /> <system value="http://unitsofmeasure.org" /> <code value="1" /> </denominator> </strength> </ingredient> <ingredient> <itemCodeableConcept> <coding> <system value="http://snomed.info/sct" /> <code value="387494007" /> <display value="codéine" /> </coding> <text value="CODEINE" /> </itemCodeableConcept> <isActive value="true" /> <strength> <numerator> <value value="30" /> <unit value="mg" /> <system value="http://unitsofmeasure.org" /> <code value="mg" /> </numerator> <denominator> <value value="1" /> <system value="http://unitsofmeasure.org" /> <code value="1" /> </denominator> </strength> </ingredient> </Medication> </contained> <status value="active" /> <intent value="order" /> <medicationReference> <reference value="#med-51" /> </medicationReference> <subject> <reference value="Patient/phast-14602" /> </subject> <authoredOn value="2021-07-28T15:12:37.603Z" /> <requester> <reference value="Practitioner/smart-Practitioner-71482713" /> </requester> <dosageInstruction> <sequence value="1" /> <timing> <repeat> <boundsPeriod> <start value="2021-07-28T15:12:00Z" /> <end value="2021-08-02T15:11:59Z" /> </boundsPeriod> <timeOfDay value="07:00:00" /> <timeOfDay value="18:00:00" /> </repeat> </timing> <route> <coding> <system value="http://snomed.info/sct" /> <code value="26643006" /> <display value="Voie orale" /> </coding> <text value="Voie orale" /> </route> <doseAndRate> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/dose-rate-type" /> <code value="ordered" /> <display value="Ordered" /> </coding> <text value="Ordered" /> </type> <doseQuantity> <value value="1" /> <system value="http://unitsofmeasure.org" /> <code value="1" /> </doseQuantity> </doseAndRate> </dosageInstruction> </MedicationRequest>