Paginate doesn't work with groupBy same as in Laravel

[ndragun92]

Paginate doesn't work with groupBy same as in Laravel (Total Records)

Message from Laravel

"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."

Example

 query = await CvLookup
        .query()
        .select('id', 'company_id')
        .sum('number as total')
        .where('day', '>=', moment(allParams.from_date).format('YYYY-MM-DD'))
        .where('day', '<=', moment(allParams.to_date).format('YYYY-MM-DD'))
        .groupBy('company_id')
        .paginate(allParams.page, allParams.limit)

Result

 {
            "total": 1,
            "perPage": 2,
            "page": 1,
            "lastPage": 1,
            "data": [
                {
                    "id": 1,
                    "company_id": 5,
                    "total": "20"
                },
                {
                    "id": 2,
                    "company_id": 5,
                    "total": "100"
                }
            ]
        }