Latest record many to many relationship

You need to define "has one of many" relation on Dossier model:

public function lastStatus(): HasOne
{
    return $this->hasOne(Status::class)->ofMany('created_at', 'max');
}

After that $dossier->lastStatus() will give you what you want.

https://laravel.com/docs/12.x/eloquent-relationships#has-one-of-many

Upd: if you need to query by particular status, then you should do so:

$dossier = Dossier::whereRelation('lastStatus', 'id', '=', $status_you_need_to_query_by)->first();

In my dossier model I have :

public function dossierStatuses(): BelongsToMany
    {
        return $this->belongsToMany(StatusTypeModel::class, 'dossier_statuses', 'dossier_id', 'type_status_id')
            ->orderBy('dossier_statuses.created_at', 'desc')
            ->withTimestamps();
    }

I tried :

DossierModel::whereHas('dossierStatuses', function ($query) use ($status) {
                    $query
                        ->where('type_status_id', $status->id)
                        ->orderBy('dossier_statuses.created_at', 'DESC')
                    ;
                })

With this query, I have all the files with this status, but I would only like the files that have this status as the last status.

The solution can be more straightforward and simpler than we all thought.

Let's ignore the relationships for now, we can write a database query using addSelect with dossier and and dosier_statuses tables only.

Dossier::addSelect(['last_status_id' => DB::table('dossier_statuses')->select('status_id')
    ->whereColumn('dossier.id', 'dossier_statuses.dossier_id')
    ->latest('dossier_statuses.id')
    ->limit(1)
])
    ->having('last_status_id', $yourSpecificStatusId)
    ->get();

Pls let me know if this works.