Adonis Query Builder: How to make .where condition on relationship

Question

So I have this query

return await Order
      .query()
      .with('order_status')
      .where('order_status.is_completed_type', true)

I want to only get the orders with order_status.is_completed_type === true

but it seems that doesn't work that way, is there a way to do this?

user_2039846 · Answer

So in your case:

return await Order
      .query()
      .with('order_status', q=> {
          q.where('is_completed_type', true)
})