I would like to know whether the below scenario is possible in Atlas table drop down widget.
For example - Our hospital data has few variants of cholestrol measurements. let’s say we have Cholestrol measurement name_A, Cholestrol measurement name_B, Cholestrol measurement name_C, Cholestrol measurement name_D etc.
Currently what we do is identify the concept id for all the above concepts and create a concept set and use it Atlas Measurement_concept_id field. This works fine.
What we are interested is to know whether there is a way to extract only our Cholesterol related measurements (In this case A,B,C,D as given above)? Rather than having to refer all the concepts related to Cholesterol from concepts table.
If I can put it other way, in SQL I use like operator to extract our cholesterol related measurement from ‘Measurement’ table and then get their concept_ids.
Is it possible to do this in Atlas or it is already there in Atlas?