Feature : Search by encounters or consultations

[nihal467]

Is your feature request related to a problem? Please describe.
Follow-up : #1787

https://care.coronasafe.in/facility/53a7266a-ed34-4616-85eb-7ae1be57d2cc/patient/4ae3b7de-800d-4b41-8ac9-00dbb741fe9f/consultation/54959916-9496-49ea-9ebe-e1ff579e5557

A Patient named "Test-daily-hospitalreport" in the facility "test-march-thirdweek" was initially admitted to the hospital

• on 01/03/2023 to a regular bed
• later on 10/03/2023 he was shifted from a regular bed to icu.
• again on 15/03/2023 he was again shifted back to a regular bed.

When we go to the patient tab, apply a filter, admitted to "regular", it generates a list of all the patients in the regular bed, by looking at their current bed status, we are not able to apply a filter to see, which all patients were admitted in a regular bed, for the period 08/03/2022 to 14/03/2022 because

1. the admit date filter in the advance filter, is only checking the initial admit date of the patient and not the bed change date of the patient
2. we are not able to use advance filter in the patient tab, to check past bed types used by a patient for a period of date and time

Edge Case in this issue: If a patient is shifted from a regular bed to icu bed on the 10th of march and we generate a specific individual report for the 10th march of the patients in regular bed and icu, the report will be double counting a patient, so we should be adding time to the filter along with the date.

Describe the solution you'd like

• create a feature to search by encounters or consultations
• it may be created on a dedicated page

[nihal467]

@aparnacoronasafe can you suggest the UX approach we should be following for this feature?

[nihal467]

closing this issue as we can achieve the same using the metabase