Mistake on query builder

[rhadamez]

Hey, Iam trying to filter a list with query builder, something like:

const query = request.clinic.appointments().orderBy('date', orderBy).with('patient', builder => builder.where('id', '3'))

But the response is bringing all appointments, instead the appointments with patient with id = 3.

Details:

[RomainLanz]

Hey @rhadamez! 👋

In this case, your code is wrong, you need to use the whereHas method and not with.
https://preview.adonisjs.com/guides/model-relations/introduction#querying-relationship-existence

[rhadamez]

Correct! thanks a lot : )