I have a simple model in which a Patient has many events. Each event has a start date and a category like 'medication'.
It is normal for a patient to have 10s of events of each category.
I would like to find patients where:
a measurement event happen...