Core Apps: Very long TTFB for patientDashboard.page when many encounters

[lluismf (Lluis Martinez)]

@mksd

and (o.encounter in (select e from Encounter e where e.visit = (select v from Visit as v where v.visitId = :visitId)))

Have you tried this instead ?

and (o.encounter.visit = :visitId)