Stream: implementers
Topic: sub-queries in advanced filters (_filter)
Behrad Sadoughian (May 05 2016 at 16:20):
Can () be used to nest one filter in another using _filters for sub-queries? I wonder how the following SQL queries can be implemented using FHIR advanced query:
SELECT * FROM A WHERE A.ID IN (SELECT ID FROM B)?
Are there any more resources/historical discussion on the following page: https://www.hl7.org/fhir/search.html and https://www.hl7.org/fhir/search_filter.html ?
Grahame Grieve (May 05 2016 at 22:25):
"A filter can contain other filters in a set of parentheses : "()"." - so yes. though I don't see that in the formal grammar
Charles Seeley (May 09 2016 at 13:55):
What should the syntax of a filter within a filter look like? Would it look something like this...
[base]/Patient/?_filter= gender eq 'X' and procedure in (procedure.performed gt 'Y' )
Grahame Grieve (May 09 2016 at 14:12):
well, that's the syntax
Charles Seeley (May 09 2016 at 14:17):
Thanks. I appreciate the response.
Last updated: Apr 12 2022 at 19:14 UTC
