CODEWITHSUNDEEP
laravel
Mia Trax Khalifa
Mia Trax Khalifa

Reputation: 46

laravel latest or order by not working from a related table

I have my code here. I just want to sort it according to the latest comments posted.

$comments = ModelsComment::with('Comments')->where('posts_id', $this->post)
   ->WhereHas('Comments', function ($q){
    $q->orderBy('created_at', 'DESC');   //->latest()
     })->paginate('5');

ModelsComment is my pivot table(no time stamps here) so i'm trying to sort it by newest comments added(Related table).

However, oldest record is still appearing from the top. Any help would be appreciated.

My Table structure looks like this

POST
id
name
timestamps

ModelsComment(without timestamps)
posts_id
comments_id

Comments
id
name
timestamps

I'm trying to query from my ModelsComment, and order the Comments table with the latest/newest entry first.

Upvotes: 0

Views: 390

Answers (1)

Tim Biegeleisen
Tim Biegeleisen

Reputation: 521028

Use this version:

$comments = ModelsComment::with(['Comments' => function ($q) {
    $q->orderBy('created_at', 'DESC')
}])
    ->paginate('5')
    ->get();

Upvotes: 2

Related Questions