Stream: implementers
Topic: FHIR Queries
Joel Francis (Jun 19 2019 at 23:08):
Hi,
Each resource has a suggested set of search parameters. However is it possible to do a sort of table join search?
ex: return a Bundle with patients suffering from condition "x" and blood pressure over "y". An advice on how we can use the existing query search would be helpful.
Thanks in advance
Lloyd McKenzie (Jun 19 2019 at 23:45):
GET [base]/Patient?_has:Observation:patient:code-value-quantity=1234-5$gtY|mmHg|http://unitsofmeasure.org&_has:Condition:patient:code=X
Lloyd McKenzie (Jun 19 2019 at 23:47):
However, be aware that you can have a Condition that matches on the code but the status could be 'refuted' or 'resolved' or something. Right now there are no composite search parameters on Condition that would let you check for code and status. (And frankly, for any search result using _has, you probably want to do an _include of those resources because they could have modifierExtensions that could exclude them from consideration.
Joel Francis (Jun 19 2019 at 23:50):
However, be aware that you can have a Condition that matches on the code but the status could be 'refuted' or 'resolved' or something. Right now there are no composite search parameters on Condition that would let you check for code and status. (And frankly, for any search result using _has, you probably want to do an _include of those resources because they could have modifierExtensions that could exclude them from consideration.
Thanks @Lloyd McKenzie
Is there also a way to search for all clinical related resources for a Patient? I know $everything will give us every resource that references the Patient at the very least.
Lloyd McKenzie (Jun 20 2019 at 00:51):
What's "clinical related"? Observation can contain labs, but it can also include "location of your valuables". Is a prior authorization for a drug clinical? What about a ResearchStudy?
Lloyd McKenzie (Jun 20 2019 at 00:55):
For something that is so subjective, it's hard to define something useful. The best bet is probably querying using GraphDefinition - where you define the GraphDefinition that reflects what your particular notion of 'clinical' is.
Joel Francis (Jun 20 2019 at 12:03):
For something that is so subjective, it's hard to define something useful. The best bet is probably querying using GraphDefinition - where you define the GraphDefinition that reflects what your particular notion of 'clinical' is.
Thanks @Lloyd McKenzie
Last updated: Apr 12 2022 at 19:14 UTC
