laravel eloquent lists - Sorting A List Of Column Values

Question

Using laravel and I'm creating a select box on a form. I've been using the helper to create the select box and all is working fine.

I retrieve the data for the select box from a database and use the following to retrieve the data:

$data = model::lists('name','id')

Again all works ok and this returns the expected array

My problem though is I can't seem to sort this list - i've tried adding orderBy() but no joy.

Other than using a native php function is there a laravel method to sort a list?

Great question. Normally need to put where's, etc on the query to create an array to populate a select with Laravel. — Andrew Koper
– Andrew Koper, Commented Feb 8, 2015 at 5:22

Umut Sirin · Accepted Answer · 2016-02-02 08:20:13Z

70

You can put whatever you want, and then list it. I mean:

model::orderBy('orderByColumn')->lists('name', 'id');

As long as lists is the last method in the chain, other methods works just fine.

Starting from Laravel version 5.3 lists is going to be deprecated, use pluck instead:

model::orderBy('orderByColumn')->pluck('name', 'id');

edited Feb 2, 2016 at 8:20

answered Jul 12, 2013 at 8:58

Umut Sirin

2,5021 gold badge23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Israel Ortuño Over a year ago

You could also use php array sorting once you get the array PHP: Sorting arrays

Ray Over a year ago

excellent - thank you. I was trying to orderBy after the lists. I hadnt realised the order of these functions. Thanks again

Andrew Koper Over a year ago

Thank you, thank you, thank you @umut-sirin. Much love from Detroit!

DutGRIFF Over a year ago

When Laravel 5.3 comes our lists will be deprecated. It has been renamed to pluck. The method signature is the same. Please don't use lists anymore as you have access to pluck in current versions.

Javier dc Over a year ago

model::orderBy('orderByColumn')->pluck('name', 'id'); not valid in my case. I found this solution: model::all()->sortby('Name')->pluck('Name', 'id');

|

Umut Sirin · Accepted Answer · 2016-02-02 09:02:56Z

4

You can try:

$data = model::select('name','id')->orderBy('name');

If that doesn't work, toss a ->get() on the end:

$data = model::select('name','id')->orderBy('name')->get();

edited Feb 2, 2016 at 9:02

Umut Sirin

2,5021 gold badge23 silver badges31 bronze badges

answered Jul 12, 2013 at 5:50

thestepafter

6181 gold badge5 silver badges21 bronze badges

1 Comment

Ray Over a year ago

Hi - I tried this also but struggled to implement the object in the html select helper the data was intended for. The result was correct but couldnt implement. Lists was easier as it contained the exact data I needed

Võ Ngọc Nhật · Accepted Answer · 2018-11-03 16:49:06Z

0

when I

dd(YourModel::pluck('name', 'id'));

I see it is Collection Class so I found collection laravel and then I found method sortKeys() so I do:

YourModel::pluck('name', 'id')->sortKeys();

answered Nov 3, 2018 at 16:49

Võ Ngọc Nhật

11 bronze badge

Collectives™ on Stack Overflow

laravel eloquent lists - Sorting A List Of Column Values

3 Answers 3

8 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

8 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related