leaf icon indicating copy to clipboard operation
leaf copied to clipboard

Published 20 hours ago • verified publisher icon uwrit

Query against list of MRNs

Open pj00 opened this issue 4 years ago • 2 comments

Let's say I have an Excel file with a column of 50 MRNs, and I want to run a query that only returns results where the MRN matches one of those 50 MRNs. How would I accomplish this in Leaf?

pj00 avatar Sep 01 '20 14:09 pj00

Hi @pj00, this is a common use case - we have an ongoing (undocumented) TODO to add a flat-file/delimited text input Import Feature, such that users can copy/paste MRNs in to create their own concepts. In fact, in the old UW-internal Leaf codebase, this was a widely-used feature.

At the moment though, the only way to do this is to do so via the REDCap Import feature (which I can help you troubleshoot through in #360).

ndobb avatar Sep 01 '20 16:09 ndobb

Good to know, thanks!

pj00 avatar Sep 01 '20 18:09 pj00