get first element from relationship eloquent

user_13255216 0
Viewed 884

i have a question about queries, how can i get the first element from a relationship hasMany in Laravel, i have a chats table with a relationship hasMany messages, i try with this, and take() and limit(), but without success

$chats = Chat::with(['messages' => function ($query) {
    $query->first();
}])->get();
eloquent laravel
3 Answers

I think, it can be exists another good solution, but with this i can make what i want

Chat model class:

public function firstMessage()
{
    return $this->hasOne(Message::class);
}

the query from controller:

Chat::with('firstMessage')->get();
user_132552160

I would suggest making a separate property for this and having the logic inside it. So this is inside Chat class:

public function getFirstMessageAttribute() 
{
    return $this->hasMany(Message::class)->orderBy('id', 'desc')->first();
}

And then you can call it like:

$chats = Chat::with('messages')->get();
$chats[0]->firstMessage; //
user_11374060

Try this:

$chats = Chat::with(['messages' => function ($query) {
    $query->limit(1)->latest();
}])->get();
user_83730440
Related