CODEWITHSUNDEEP
phpmysqlsqllaravellaravel-5.4
VMeijer
VMeijer

Reputation: 433

Laravel 5.4 sorting

I've got 2 columns, Model and Action. First thing I would like to achieve is to order the model from A to Z.

I'm doing that with 

orderBy('model', 'ASC')

Then I would like to order the action column on index, create, store etc. I've got a query, and i'me trying to sort the results in order: index, create, store, show, edit, update, destroy, [everything else].

However the result i'm getting is: [everything else], index, create, store, show, edit, update, destroy

Query:

Permission::orderBy('model', 'ASC')->orderByRaw("FIELD(action, 'index', 'create', 'store', 'show', 'edit', 'update', 'destroy')")->get();

Result should be something like:

Has anyone got an idea how I can fix this?

Thanks

Upvotes: 4

Views: 23312

Answers (1)

Mayank Pandeyz
Mayank Pandeyz

Reputation: 26258

The orderBy method allows you to sort the result of the query by a given column. The first argument to the orderBy method should be the column you wish to sort by, while the second argument controls the direction of the sort and may be either asc or desc, check the example:

$users = DB::table('table')
->orderBy('name', 'desc')  // You can pass as many columns as you want
->get();

Upvotes: 8

Related Questions