Order By before Group By using Eloquent (Laravel)

by

I just needed to do something similar with a messages model. What worked for me was applying the unique method on the returned eloquent collection. 

Model::where('toId', $id)
    ->orderBy('createdAt', 'desc')
    ->get()
    ->unique('fromId');

The query will return all messages ordered by createdAt and the unique method will reduce it down to one message for each fromId. This is obviously not as performant as using the database directly, but in my case I have further restrictions on the query.

Also, there are many more useful methods for working with these collections: https://laravel.com/docs/5.2/collections#available-methods

More Related Contents:

  1. Property Property Property [title] does not exist on this collection instance does not exist on this collection instance does not exist on this collection instance
  2. Automatically deleting related rows in Laravel (Eloquent ORM)
  3. Get Specific Columns Using “With()” Function in Laravel Eloquent
  4. How do I get the query builder to output its raw SQL query as a string?
  5. How to do this in Laravel, subquery where in
  6. Laravel Eloquent Query Using WHERE with OR AND OR?
  7. Laravel Check If Related Model Exists
  8. Laravel update model with unique validation rule for attribute
  9. How can I convert many statement mysql to laravel eloquent?
  10. Eloquent ORM Code Hinting in PhpStorm
  11. Laravel Model with Two Primary Keys update [duplicate]
  12. Laravel eager loading with limit
  13. Get the Query Executed in Laravel 3/4
  14. What does “Mass Assignment” mean in Laravel?
  15. Laravel OrderBy relationship count
  16. Laravel Checking If a Record Exists
  17. Laravel Eloquent: How to order results of related models?
  18. How to set a default attribute value for a Laravel / Eloquent model?
  19. Laravel 5 hasMany relationship on two columns
  20. Laravel – Database, Table and Column Naming Conventions?
  21. How to Make Laravel Eloquent “IN” Query?
  22. How to Merge Two Eloquent Collections?
  23. How to create a subquery using Laravel Eloquent?
  24. Eloquent model mass update
  25. Difference between Eloquent\Model::get() and all()
  26. Laravel 4.1: How to paginate eloquent eager relationship?
  27. Eloquent many-to-many-to-many – how to load distant relation easily
  28. Find or Create with Eloquent
  29. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  30. Laravel Eloquent update just if changes have been made

Leave a Comment