Stream: implementers
Topic: Filtering ResearchStudy by size?
Paul Lynch (Mar 12 2021 at 22:08):
Is there a way to find ResearchStudies with a given number of ResearchSubjects? I could send one query per ResearchStudy to get the count of each, but in a database where there are thousands of studies, that would be really slow. I think maybe "size" search parameter is needed for ResearchStudy.
Lloyd McKenzie (Mar 12 2021 at 22:09):
@Smita Hastak @Hugh Glover
Hugh Glover (Mar 15 2021 at 09:07):
We were talking about "number of subjects" on the calls last week. There was debate about desired number vs actual number, and also whether it was per site as well as per study. You seem to be asking a slightly different question "find all sites with 550 subjects" is how I read "given number of subjects". DO you really want that or do you just want the number of subjects? Either way happy to think about adding it as a search parameter.
Paul Lynch (Mar 15 2021 at 23:29):
I was actually thinking of finding ResearchStudies with at least X subjects, and was asking because Clem McDonald wanted to be able to do that in a tool we're developing. You raise good questions though about "desired" vs "actual" and site counts vs total. I will check with Clem to be sure of what he wanted.
Lloyd McKenzie (Mar 16 2021 at 05:27):
There'll be separate ResearchStudy instances for the overall study and for each location - and each would have their own Group defining membership criteria. We don't have "target number" though - that would have to be an extension or new element, but we could define a standard search criteria on it.
Hugh Glover (Mar 17 2021 at 19:22):
"We don't have a target number" ... Well actually we are discussing a change at the moment that would allow us to distinguish target from actual
Hugh Glover (Mar 29 2021 at 08:49):
https://jira.hl7.org/browse/FHIR-25239 is on the same topic. We are implementing a simple numeric search, but there is a question on what more might be needed. Any use cases appreciated.
Paul Lynch (Mar 29 2021 at 18:28):
Clem clarified he is interested in querying on the actual number of subjects (not the desired number), and the total number rather than per study site.
Hugh Glover (Mar 29 2021 at 19:07):
That should be covered - it was just the simple search we were thinking of.
Last updated: Apr 12 2022 at 19:14 UTC
