CODEWITHSUNDEEP
mysqllaraveleloquent
zarpio
zarpio

Reputation: 7338

Laravel 5.6 chunk with groupBy

I am getting the error while executing below, while without groupBy it is working fine.

    User::select('col')->groupBy('col1')->chunk(100, function ($users) {
        foreach ($users as $user) {
            dump($user);
        }
    });

Error:

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column

Upvotes: 4

Views: 2397

Answers (1)

bhavinjr
bhavinjr

Reputation: 1763

you can do something like that need to use orderBy

User::select('col')
    ->orderBy('col1')
    ->groupBy('col1')
    ->chunk(100, function ($users) {
        foreach ($users as $user) {
            // code ..
        }
    });

Upvotes: 2

Related Questions