how to use pagination in groupby & orderby clause for fetching records in laravel by year wise

Question

$newsYearCount = news::paginate(5)->groupBy(function($date) {
                      return Carbon::parse($date->created_at)->format('Y'); //
                  });

i want to use order By for above code and also it just group By 5 records, but i want a records like firstly it should group By and then apply pagination.

score 0 · Accepted Answer · edited May 23 '17 at 12:25

0

Currently, pagination operations that use a groupBy statement cannot be executed efficiently by Laravel. If you need to use a groupBy with a paginated result set, it is recommended that you query the database and create a paginator manually.

check here: https://laravel.com/docs/5.3/pagination#basic-usage

check this for order by : https://stackoverflow.com/a/19885982/2815635

edited May 23 '17 at 12:25

Community

1
1

answered Jan 13 '17 at 13:30

Niklesh Raut

34,013
16
75
109

can you suggest a code from which i will get results yearwise with pagination? – Elitabi Invitra Jan 13 '17 at 13:36

how to use pagination in groupby & orderby clause for fetching records in laravel by year wise

1 Answers1