Laravel: orderBy a column with collections

Question

I need to OrderBy a column with collection.

I need to orderBy(updated_at, 'desc') all posts which owned by current logged user.

Here is my code :

$posts = auth()->user()->posts->sortByDesc('updated_at');

Here is User model :

class User extends Authenticatable
{
    public function posts()
    {
      return $this->hasMany(Post::class);
    }
}

It doesn't return any errors also doesn't sort !

Any helps would be great appreciated.

P.S:

I know I can achieve this with :

$posts = Post::where('user_id', auth()->user()->id)->orderBy('updated_at', 'desc')->get();

But I would like to do the same thing with collections.

Try to use `->latest()` instead of `->sortByDesc('updated_at');` its the same thing — Onix, Mar 17 '17 at 10:21
Its not that easy `$posts = auth()->user()->posts->sortBy(function($post){return $post->updated_at;})->reverse();`. This should work. — Autista_z, Mar 17 '17 at 10:26

score 80 · Accepted Answer · edited Nov 13 '19 at 21:23

80

So this is how you sort with SQL:

$posts = auth()->user()->posts()->orderBy('updated_at', 'DESC');

And with collections:

$posts = auth()->user()->posts->sortByDesc('updated_at');

I've tested the 2nd one and it works as intended for me.

edited Nov 13 '19 at 21:23

answered Mar 17 '17 at 11:20

DevK

11

For any lurkers, if you would like to sort by ascending instead, simply use `sortBy()` instead of `sortByDesc()` on collections. There is no function named `sortByAsc()`. – Chad Mar 13 '19 at 04:06
How about multiple order? i'm not getting the right array for multiple sort – Ray Coder Oct 30 '20 at 12:08
sortByAsc() is not working for me using Laravel 8 – Fernando Torres Nov 25 '21 at 01:39
I think sortBy defaults to Asc – senecaTheMeek Jun 10 '22 at 13:34

Hamed Kamrava · Answer 2 · 2019-08-27T14:42:24.420

6

@devk is right. What I wrote in the first post is correct.

The problem was in DataTables in the the view.

It needed to add this line to the Datatables options:

"order": [[ 5, 'desc' ]], // 5 is the `updated_at` column (the sixth column in my case)

So this is working fine :

$posts = auth()->user()->posts->sortByDesc('updated_at');

edited Aug 27 '19 at 14:42

answered Mar 17 '17 at 12:27

Hamed Kamrava

score 4 · Answer 3 · answered Mar 17 '17 at 10:40

4

Try adding the following to your User model

public function posts_sortedByDesc(){
      return $this->hasMany(Post::class)->sortByDesc('updated_at');
   }

Then get the posts by calling posts_sortedByDesc instead of posts

answered Mar 17 '17 at 10:40

Jesse de gans

3 Answers3