Filter or query on hasManyThrough's property #8375
Unanswered
A-Corregidor
asked this question in
Q&A
Replies: 1 comment
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Scenario (based on doc)
DOCTOR
{id: number, name: string}
PATIENT
{id: number, name: string}
APPOINTMENT
{id: number, doctorId: number, patientId: number, meetingHours: number}
Is it possible to query all doctor's patients that have been on a meeting for more than 1 hour?
Ex:
doctorId : 2 -> [{id: 2, name: "Ronald"},{id: 4, name: "Anne"}]
Is it possible to query all doctor's patients, listing its meeting's duration?
Ex:
doctorId : 1 -> [{id: 1, name: "Eve", "meetingHours": 3}, {id: 2, name: "Ronald", "meetingHours": 1},{id: 3, name: "Philipe", "meetingHours": 1}]
Thanks
Beta Was this translation helpful? Give feedback.
All reactions