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.
<Bundle xmlns="http://hl7.org/fhir"> <id value="example-Bundle-observation-alert-search" /> <type value="searchset" /> <total value="18" /> <link> <relation value="self" /> <url value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation?focus=Coverage/RA783107621&category=https%3A//bpcs.exchange/fhir/CodeSystem/cs-NoteCode%7C24,https%3A//bpcs.exchange/fhir/CodeSystem/cs-NoteCode%7C25" /> </link> <entry> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-25-456" /> <resource> <Observation> <id value="RA783107621-25-456" /> <contained> <Provenance> <id value="1" /> <target> <reference value="#" /> </target> <occurredDateTime value="2024-02-21T18:24:48.153-04:00" /> <activity> <coding> <system value="http://terminology.hl7.org/CodeSystem/v3-DataOperation" /> <code value="CREATE" /> </coding> </activity> <agent> <who> <identifier> <system value="https://bpcs.exchange/fhir/NamingSystem/userids" /> <value value="TH_KAGLU" /> </identifier> </who> </agent> </Provenance> </contained> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25-456" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="true" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-24-453" /> <resource> <Observation> <id value="RA783107621-24-453" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="24" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="24-453" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-24-454" /> <resource> <Observation> <id value="RA783107621-24-454" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="24" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="24-454" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-24-455" /> <resource> <Observation> <id value="RA783107621-24-455" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="24" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="24-455" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-24-511" /> <resource> <Observation> <id value="RA783107621-24-511" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="24" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="24-511" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-25-457" /> <resource> <Observation> <id value="RA783107621-25-457" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25-457" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-25-458" /> <resource> <Observation> <id value="RA783107621-25-458" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25-458" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-25-512" /> <resource> <Observation> <id value="RA783107621-25-512" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25-512" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-25-513" /> <resource> <Observation> <id value="RA783107621-25-513" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25-513" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-25-514" /> <resource> <Observation> <id value="RA783107621-25-514" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25-514" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-25-515" /> <resource> <Observation> <id value="RA783107621-25-515" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25-515" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-25-516" /> <resource> <Observation> <id value="RA783107621-25-516" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25-516" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-25-517" /> <resource> <Observation> <id value="RA783107621-25-517" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25-517" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-25-518" /> <resource> <Observation> <id value="RA783107621-25-518" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25-518" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-25-520" /> <resource> <Observation> <id value="RA783107621-25-520" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25-520" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-25-521" /> <resource> <Observation> <id value="RA783107621-25-521" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25-521" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-25-604" /> <resource> <Observation> <id value="RA783107621-25-604" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25-604" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <entry> <!-- This entry is inferred because all possible alerts and special conditions are always returned --> <fullUrl value="https://api.bpcs.exchange/rest/v1/dev/THP/BPCS_vs1/Observation/RA783107621-25-605" /> <resource> <Observation> <id value="RA783107621-25-605" /> <status value="final" /> <category> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25" /> </coding> </category> <code> <coding> <system value="https://bpcs.exchange/fhir/CodeSystem/cs-NoteCode" /> <code value="25-605" /> </coding> </code> <subject> <reference value="Group/example-Group" /> <!-- This would normally be Group/RA783107621 --> </subject> <focus> <reference value="Coverage/example-Coverage-family" /> <!-- This would normally be Coverage/RA783107621 --> </focus> <effectiveDateTime value="2024-02-21" /> <!-- This will be the current date/time --> <issued value="2024-02-21T18:24:48.153-04:00" /> <valueBoolean value="false" /> </Observation> </resource> <search> <mode value="match" /> </search> </entry> <!-- <ca.ontario.health.hns.web.dto.am.AlertSpecialHandlingSettingDTO> <dirty>false</dirty> <activities> <ca.ontario.health.hns.web.dto.am.AlertSpecialHandlingDTO> <dirty>false</dirty> <recCreateModuleId>BPCS </recCreateModuleId> <recUpdateModuleId>BPCS </recUpdateModuleId> </ca.ontario.health.hns.web.dto.am.AlertSpecialHandlingDTO> </activities> </ca.ontario.health.hns.web.dto.am.AlertSpecialHandlingSettingDTO> --> </Bundle>