Laravel Eloquent Ordering results of all

Question

I m stuck on a simple task   I just need to order results coming from this call    results   Project  all      Where Project is a model  I ve tried this   results   Project  all  - gt orderBy  name      But it didn t work  Which is the better way to obtain all data from a table and get them ordered

User · Answer

Check out the sortBy method for Eloquent  http   laravel com docs eloquent

User · Answer

Try this   categories         Category  all  - gt sortByDesc  quot created at quot

User · Answer

While you need result for date as desc    results   Project  latest  created at  - gt get

User · Answer

DO THIS   results   Project  orderBy  name  - gt get     Why  Because it s fast  The ordering is done in the database  DON T DO THIS   results   Project  all  - gt sortBy  name     Why  Because it s slow  First  the the rows are loaded from the database  then loaded into Laravel s Collection class  and finally  ordered in memory

User · Answer

Note  you can do    results   Project  select  name  - gt orderBy  name  - gt get      This generate a query like    SELECT name FROM proyect ORDER BY  name  ASC    In some apps when the DB is not optimized and the query is more complex  and you need prevent generate a ORDER BY in the finish SQL  you can do    result   Project  select  name  - gt get     result    result- gt sortBy  name     result    result- gt values  - gt all      Now is php who order the result

User · Answer

You can actually do this within the query    results   Project  orderBy  name  - gt get      This will return all results with the proper order

User · Answer

2017 update    Laravel 5 4 added orderByDesc   methods to query builder    results   Project  orderByDesc  name  - gt get

User · Answer

You instruction require call to get  because is it bring the records and orderBy the catalog  results   Project  orderBy  name              - gt get     Example   results   Result  where   id     gt      20   - gt orderBy  id    desc   - gt get     In the example the data is filtered by  quot where quot  and bring records greater than 20 and orderBy catalog by order from high to low

User · Answer

In addition  just to buttress the former answers  it could be sorted as well either in descending desc or ascending asc orders by adding either as the second parameter    results   Project  orderBy  created at    desc  - gt get

User · Answer

One interesting thing is multiple order by  according to laravel docs  DB  table  users      - gt orderBy  priority    desc      - gt orderBy  email    asc      - gt get     this means laravel will sort result based on priority attribute  when it s done  it will order result with same priority based on email internally

User · Answer

You could still use sortBy  at the collection level  instead of orderBy  at the query level  if you still want to use all   since it returns a collection of objects   Ascending Order   results   Project  all  - gt sortBy  name      Descending Order   results   Project  all  - gt sortByDesc  name      Check out the documentation about Collections for more details   https   laravel com docs 5 1 collections

[laravel] Laravel Eloquent: Ordering results of all()

Examples related to laravel

Examples related to laravel-4

Examples related to eloquent

Examples related to sql-order-by