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.
<Questionnaire xmlns="http://hl7.org/fhir"> <id value="core-examples-Questionnaire-example11" /> <meta> <versionId value="3" /> <lastUpdated value="2016-09-08T12:21:39.316+00:00" /> </meta> <text> <status value="generated" /> --- We have skipped the narrative for better readability of the resource --- </text> <status value="published" /> <group> <linkId value="root" /> <title value="(Ask Richard)" /> <required value="true" /> <repeats value="false" /> <group> <linkId value="1" /> <title value="MARGINS" /> <required value="true" /> <repeats value="false" /> <question> <linkId value="1.1" /> <text value="Status of surgical margin involvement by tumor (observable entity)" /> <type value="choice" /> <required value="true" /> <repeats value="false" /> <option> <code value="M1" /> <display value="Margins univolved by tumor" /> </option> <option> <code value="M2" /> <display value="Margin(s) involved by tumor" /> </option> <option> <code value="M3" /> <display value="Cannot be determined" /> </option> <option> <code value="M4" /> <display value="Not applicable" /> </option> <group> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-enableWhen"> <extension url="#question"> <valueString value="1.1" /> </extension> <extension url="#answer"> <valueCoding> <code value="M1" /> </valueCoding> </extension> </extension> <linkId value="1.1.1" /> <required value="true" /> <repeats value="false" /> <question> <linkId value="1.1.1.1" /> <text value="Distance from Closest Margin" /> <type value="choice" /> <required value="false" /> <repeats value="false" /> <option> <code value="D1" /> <display value="Specify (mm)" /> </option> <option> <code value="D2" /> <display value="Cannot be assessed (explain)" /> </option> <group> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-enableWhen"> <extension url="#question"> <valueString value="1.1.1.1" /> </extension> <extension url="#answer"> <valueCoding> <code value="D1" /> </valueCoding> </extension> </extension> <linkId value="1.1.1.1.1" /> <required value="true" /> <repeats value="false" /> <question> <extension url="http://hl7.org/fhir/StructureDefinition/minValue"> <valueDecimal value="0.01" /> </extension> <extension url="http://hl7.org/fhir/StructureDefinition/maxValue"> <valueDecimal value="1000" /> </extension> <extension url="http://hl7.org/fhir/StructureDefinition/maxDecimalPlaces"> <valueInteger value="2" /> </extension> <linkId value="1.1.1.1.1.1" /> <text value="Specify (mm)" /> <type value="decimal" /> <required value="true" /> <repeats value="false" /> </question> </group> <group> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-enableWhen"> <extension url="#question"> <valueString value="1.1.1.1" /> </extension> <extension url="#answer"> <valueCoding> <code value="D2" /> </valueCoding> </extension> </extension> <linkId value="1.1.1.1.2" /> <required value="true" /> <repeats value="false" /> <question> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-maxLength"> <valueInteger value="4000" /> </extension> <linkId value="1.1.1.1.2.1" /> <text value="Cannot be assessed (explain)" /> <type value="string" /> <required value="true" /> <repeats value="false" /> </question> </group> </question> <question> <linkId value="1.1.1.2" /> <text value="Specify Margin, if possible" /> <type value="choice" /> <required value="false" /> <repeats value="false" /> <option> <code value="W1" /> <display value="Specify margin" /> </option> <option> <code value="W2" /> <display value="Cannot be determined (explain)" /> </option> <group> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-enableWhen"> <extension url="#question"> <valueString value="1.1.1.2" /> </extension> <extension url="#answer"> <valueCoding> <code value="W1" /> </valueCoding> </extension> </extension> <linkId value="1.1.1.2.1" /> <required value="true" /> <repeats value="false" /> <question> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-maxLength"> <valueInteger value="4000" /> </extension> <linkId value="1.1.1.2.1.1" /> <text value="Specify margin" /> <type value="string" /> <required value="true" /> <repeats value="false" /> </question> </group> <group> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-enableWhen"> <extension url="#question"> <valueString value="1.1.1.2" /> </extension> <extension url="#answer"> <valueCoding> <code value="W2" /> </valueCoding> </extension> </extension> <linkId value="1.1.1.2.2" /> <required value="true" /> <repeats value="false" /> <question> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-maxLength"> <valueInteger value="4000" /> </extension> <linkId value="1.1.1.2.2.1" /> <text value="Cannot be determined (explain)" /> <type value="string" /> <required value="true" /> <repeats value="false" /> </question> </group> </question> </group> <group> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-enableWhen"> <extension url="#question"> <valueString value="1.1" /> </extension> <extension url="#answer"> <valueCoding> <code value="M2" /> </valueCoding> </extension> </extension> <linkId value="1.1.2" /> <required value="true" /> <repeats value="false" /> <question> <linkId value="1.1.2.1" /> <text value="Specify Margin(s), if possible" /> <type value="choice" /> <required value="true" /> <repeats value="false" /> <option> <code value="I1" /> <display value="Specify margin(s)" /> </option> <option> <code value="I2" /> <display value="Cannot be determined (explain)" /> </option> <group> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-enableWhen"> <extension url="#question"> <valueString value="1.1.2.1" /> </extension> <extension url="#answer"> <valueCoding> <code value="I1" /> </valueCoding> </extension> </extension> <linkId value="1.1.2.1.1" /> <required value="true" /> <repeats value="false" /> <question> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-maxLength"> <valueInteger value="4000" /> </extension> <linkId value="1.1.2.1.1.1" /> <text value="Specify margin(s)" /> <type value="string" /> <required value="true" /> <repeats value="false" /> </question> </group> <group> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-enableWhen"> <extension url="#question"> <valueString value="1.1.2.1" /> </extension> <extension url="#answer"> <valueCoding> <code value="I2" /> </valueCoding> </extension> </extension> <linkId value="1.1.2.1.2" /> <required value="true" /> <repeats value="false" /> <question> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-maxLength"> <valueInteger value="4000" /> </extension> <linkId value="1.1.2.1.2.1" /> <text value="Cannot be determined (explain)" /> <type value="string" /> <required value="true" /> <repeats value="false" /> </question> </group> </question> </group> <group> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-enableWhen"> <extension url="#question"> <valueString value="1.1" /> </extension> <extension url="#answer"> <valueCoding> <code value="M3" /> </valueCoding> </extension> </extension> <linkId value="1.1.3" /> <required value="true" /> <repeats value="false" /> <question> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-maxLength"> <valueInteger value="4000" /> </extension> <linkId value="1.1.3.1" /> <text value="Cannot be determined" /> <type value="string" /> <required value="true" /> <repeats value="false" /> </question> </group> <group> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-enableWhen"> <extension url="#question"> <valueString value="1.1" /> </extension> <extension url="#answer"> <valueCoding> <code value="M4" /> </valueCoding> </extension> </extension> <linkId value="1.1.4" /> <required value="true" /> <repeats value="false" /> <question> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-maxLength"> <valueInteger value="4000" /> </extension> <linkId value="1.1.4.1" /> <text value="Not Applicable" /> <type value="string" /> <required value="true" /> <repeats value="false" /> </question> </group> </question> </group> <group> <linkId value="2" /> <title value="ACCESSORY FINDINGS" /> <required value="true" /> <repeats value="false" /> <question> <linkId value="2.1" /> <text value="Treatment Effect (applicable to carcinomas treated with neoadjuvant therapy)" /> <type value="choice" /> <required value="false" /> <repeats value="false" /> <option> <code value="E1" /> <display value="Not identified" /> </option> <option> <code value="E2" /> <display value="Present (specify)" /> </option> <option> <code value="E3" /> <display value="Indeterminate" /> </option> <group> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-enableWhen"> <extension url="#question"> <valueString value="2.1" /> </extension> <extension url="#answer"> <valueCoding> <code value="E1" /> </valueCoding> </extension> </extension> <linkId value="2.1.1" /> <required value="true" /> <repeats value="false" /> <question> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-maxLength"> <valueInteger value="4000" /> </extension> <linkId value="2.1.1.1" /> <text value="Not identified" /> <type value="string" /> <required value="true" /> <repeats value="false" /> </question> </group> <group> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-enableWhen"> <extension url="#question"> <valueString value="2.1" /> </extension> <extension url="#answer"> <valueCoding> <code value="E2" /> </valueCoding> </extension> </extension> <linkId value="2.1.2" /> <required value="true" /> <repeats value="false" /> <question> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-maxLength"> <valueInteger value="4000" /> </extension> <linkId value="2.1.2.1" /> <text value="Present (specify)" /> <type value="string" /> <required value="true" /> <repeats value="false" /> </question> </group> <group> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-enableWhen"> <extension url="#question"> <valueString value="2.1" /> </extension> <extension url="#answer"> <valueCoding> <code value="E3" /> </valueCoding> </extension> </extension> <linkId value="2.1.3" /> <required value="true" /> <repeats value="false" /> <question> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-maxLength"> <valueInteger value="4000" /> </extension> <linkId value="2.1.3.1" /> <text value="Indeterminate" /> <type value="string" /> <required value="true" /> <repeats value="false" /> </question> </group> </question> <question> <linkId value="2.2" /> <text value="Tumor Description" /> <type value="choice" /> <required value="false" /> <repeats value="true" /> <option> <code value="U1" /> <display value="Hemorrhagic" /> </option> <option> <code value="U2" /> <display value="Necrotic" /> </option> <option> <code value="U3" /> <display value="Invasion" /> </option> <option> <code value="U4" /> <display value="Other (specify)" /> </option> <group> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-enableWhen"> <extension url="#question"> <valueString value="2.2" /> </extension> <extension url="#answer"> <valueCoding> <system value="http://cap.org/example/fhir/tumor-description" /> <code value="U3" /> </valueCoding> </extension> </extension> <linkId value="2.2.1" /> <required value="true" /> <repeats value="false" /> <question> <linkId value="2.2.1.1" /> <text value="??" /> <type value="choice" /> <required value="false" /> <repeats value="true" /> <option> <code value="V1" /> <display value="Capsule" /> </option> <option> <code value="V2" /> <display value="Vessels" /> </option> <option> <code value="V3" /> <display value="Extra-adrenal (specify)" /> </option> <group> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-enableWhen"> <extension url="#question"> <valueString value="2.2.1.1" /> </extension> <extension url="#answer"> <valueCoding> <code value="V3" /> </valueCoding> </extension> </extension> <linkId value="2.2.1.1.1" /> <required value="true" /> <repeats value="false" /> <question> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-maxLength"> <valueInteger value="4000" /> </extension> <linkId value="2.2.1.1.1.1" /> <text value="Extra-adrenal (specify)" /> <type value="string" /> <required value="true" /> <repeats value="false" /> </question> </group> </question> </group> <group> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-enableWhen"> <extension url="#question"> <valueString value="2.2" /> </extension> <extension url="#answer"> <valueCoding> <system value="http://cap.org/example/fhir/tumor-description" /> <code value="U4" /> </valueCoding> </extension> </extension> <linkId value="2.2.2" /> <required value="true" /> <repeats value="false" /> <question> <extension url="http://hl7.org/fhir/StructureDefinition/questionnaire-maxLength"> <valueInteger value="4000" /> </extension> <linkId value="2.2.2.1" /> <text value="Other (specify)" /> <type value="string" /> <required value="true" /> <repeats value="false" /> </question> </group> </question> </group> </group> </Questionnaire>