Why not working on laravel paginate() method with the sortBy?

Question

Why not working on laravel paginate() method with the sortBy?

Trying to do pagination in laravel, but that's what happened plugging.
If the output of the news list on 5 pieces, then do so
$news = News::paginate(5);
and everything works fine. Links to pages output using {!! $news->render() !!}

But I need the records removed from the database sorted by a specific field.
Without pagination I did so
$news = News::all()->sortBy('sort');
But if you add a method paginate() ie
$news = News::all()->sortBy('sort')->paginate(5)
it complains that the method paginate() not found.

I tried to do so
News::all()->paginate(5)->sortBy('sort')
in this case the sampling has occurred, the records displayed on the screen, but does not display links to pages, ie does not work {!! $news->render() !!} (write the render() method not found).
His head broke do not understand how to show records with pagination while using sort.

Liam.Mosciski asked July 9th 19 at 13:26

More answers about "Why not working on laravel paginate() method with the sortBy?"

1 answer

jules_Nolan10 answered on · Accepted Answer · 2019-07-09T13:28:07.748Z

jules_Nolan10 answered on July 9th 19 at 13:28

Solution

News::orderBy('sort')->paginate(5);

Works, thank you! Damn, how did I ever get this method sortBy()? From the old version of Caravela chtoli... )) - Liam.Mosciski commented on July 9th 19 at 13:31

sortBy is invoked on the existing collection. And orderBy is a method of the query Builder. - jules_Nolan10 commented on July 9th 19 at 13:34