Level 74
Try removing the get(), the paginate() does the same thing a get but instead of getting all the records it paginates them.
Aug 7, 2022
6
Level 1
How to get pagination with groupBy in eloquent?
Dear, I have a query like this - return $query->get()->groupBy('date');
It works fine but I want to add pagination on it, while I use- return $query->get()->groupBy('date')->paginate(10) , it does not working. can anyone suggest how to make it okey?
Level 1
@Tray2 get() does not work with groupBy, ensure of that pls.
I found forPage can resolve the need.
anyway, Thanks Sir :P
Level 102
@md_imran if you solved it, your should post the answer so it may help others
Level 74
Level 102
@md_imran a bit of inspiration for learning groupBy https://sinnbeck.dev/posts/laravel-groupby-error
1 like
Level 102
You need to do the groupBy in the query. But what is the expected result?
1 like
Please or to participate in this conversation.