Filter model by latest relationship value

[melokki]

Hello
I am trying to write a query to filter by a relationship but I am having some issues

I have a Order model and a OrderStatus
the Order model hasMany OrderStatus

What I want to achieve is to be able to filter all the orders that have the latest status some status, for example placed

I managed to write this query, to get the latest status of the order when I preload the statuses, but the problem is that if a order gets a new status I will still get it in the results because in the past it had the status I am looking for. I need to filter based on the latest status

const orders = await Order.query()
        .preload('statuses', (query) => {
          query.groupOrderBy('created_at', 'desc').groupLimit(1)
        })
        .whereHas('statuses', (query) => {
          query.where('status', status)
        })