Stream: implementers
Topic: How to do Fhir “not in” search
Тимофеев Николай (Nov 10 2020 at 02:08):
I need get Practitioners that do not have QuestionnaireResponse for specific Questionnaire.
SQL analog
Select Practitioners p where p.id not in (Select qr.source.id from QuestionnaireResponse qr where qr.questionnaire=‘http://fhir/Questionnaire/12345’ )
Lloyd McKenzie (Nov 10 2020 at 03:14):
You could possibly do it with _filter (though that's not widely implemented). There's no way to do it with simple RESTful query.
Paul Church (Nov 10 2020 at 03:20):
Alternately, use an implementation with good SQL-on-FHIR support and run the SQL query.
Lloyd McKenzie (Nov 10 2020 at 03:22):
That can work if the server you're using supports it.
Last updated: Apr 12 2022 at 19:14 UTC
