EU Cookie Consent

To use this Website we are using Cookies and collecting some Data. To be compliant with the EU GDPR we give you to choose if you allow us to use certain Cookies and to collect some Data.

Essential Data

The Essential Data is needed to run the Site you are visiting technically. You can not deactivate them.


Laravel sorting paginated content

Max Hutschenreiter -

Have you ever been in a situation where you want to run the sortBy method, to sort content by specific relation on an object, but the content is paginated also?

In that scenario, you can only sort per page and not the overall result.

So we have:


and that would work perfectly, but the problem is simple, you can’t call ->paginate(x) on the collection which get() returns.

In that scenario, it’s time to go to the very top of your controller and to append the following uses:
use Illuminate\Pagination\Paginator;
use Illuminate\Support\Collection;
use Illuminate\Pagination\LengthAwarePaginator;
Next thing to do, is to implement the following function which enables you to paginate collection, and it needs to look like:
private function paginate($items, $perPage = 5, $page = null, $options = [])
    $page = $page ?: (Paginator::resolveCurrentPage() ?: 1);
    $items = $items instanceof Collection ? $items : Collection::make($items);
    return new LengthAwarePaginator($items->forPage($page, $perPage), $items->count(), $perPage, $page, $options);
And than, in that controller, you can use $this->paginate($exampleContent->get(), 10),  which will paginate your collection same way as ->paginate(10) would do on a query, and contain all same functions.

I’m totally sure that you can find a better place for this function, but I’ve used the controller just as a quick example for educational purposes.

Tags: Laravel · Laravel sortby · sort pagination · sort paginated content

Want products news and updates?

Sign up for our newsletter to stay up to date.

We care about the protection of your data. Read our Privacy Policy.

Impressions from our Team

  • #Office #Garden - #

  • #workhard - #

  • #belgrade #skyline - #

  • #happybirthday Phil :) - #

  • #happybirthday Stefan 🥂 - #

  • #happybirthday Lidija 🍾 - #

  • Say hi 👋 to our newest team member ☕️ - #

  • #bithday #cake 😻 - #

  • #stayathome #homeoffice #42coders - #

  • #stayathome #homeoffice #42coders #starwars :) - #

  • #stayathome #homeoffice #42coders - #

  • We had a really nice time with #laracononline #laravel - #

  • Happy Birthday 🎂 Miloš - #

  • Happy Birthday 🎂Nikola - #

  • #42coders #christmas #dinner what a nice evening :) - #

  • Happy Birthday 🎂 Ognjen - #

  • Wish you all a merry Christmas 🎄🎁 - #

  • #happybirthday Luka! - #

  • Triff dich mit Menschen aus deiner Umgebung die deine Interessen teilen :) Wir sind gerade live gegangen und freuen uns über jede neue Community die zu uns kommt ❤️ - #

  • Nice #meetup at #myposter thanks! - #

© 2020 42coders All rights reserved.