Stream: IG creation
Topic: Simplifier FQL Ungrouping
Kevin Mayfield (Jul 01 2021 at 10:04):
Hi,
I'm after displaying all the searchParameters for a resource and have a FQL statement like this
from CapabilityStatement
where url='https://fhir.nhs.uk/CapabilityStatement/apim-medicines-conformance'
for rest.resource where type = 'MedicationRequest'
select searchParam.name, searchParam.type, searchParam.documentation
How do I un-group the results so I get a separate entry for each searchParam
Kevin Mayfield (Jul 01 2021 at 10:06):
At the moment getting this
image.png
@Ward Weistra
Ward Weistra (Jul 01 2021 at 12:46):
@Kevin Mayfield In Firely Terminal 2.2 you can already test FQL 3:
image.png
See https://simplifier.net/docs/FQL/Groupunwrapping2
from CapabilityStatement
where url='https://fhir.nhs.uk/CapabilityStatement/apim-medicines-conformance'
for rest.resource where type = 'MedicationRequest'
select searchParam {name, type, documentation}
Ward Weistra (Jul 01 2021 at 12:47):
This will come with the next Simplifier release, together with Joins.
Kevin Mayfield (Jul 01 2021 at 13:39):
answered
Martijn Harthoorn (Jul 02 2021 at 09:06):
Until then you can probably use the .where() function of FhirPath:
from CapabilityStatement
where url='https://fhir.nhs.uk/CapabilityStatement/apim-medicines-conformance'
for rest.resource.where(type = 'MedicationRequest').searchParam
select name, type, documentation"
Ward Weistra (Jul 02 2021 at 09:19):
@Kevin Mayfield :point_up:
Last updated: Apr 12 2022 at 19:14 UTC
