PHPackages                             larahook/distinct-on-pagination - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. larahook/distinct-on-pagination

ActiveLibrary[Database & ORM](/categories/database)

larahook/distinct-on-pagination
===============================

ORM Multiple distinct() with paginate()

v1.1.5(2y ago)4709MITPHPPHP ^8.0

Since Apr 2Pushed 2y ago1 watchersCompare

[ Source](https://github.com/Mishanki/laravel-distincton-pagination)[ Packagist](https://packagist.org/packages/larahook/distinct-on-pagination)[ Docs](https://github.com/Mishanki/laravel-distincton-pagination)[ RSS](/packages/larahook-distinct-on-pagination/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (1)Dependencies (2)Versions (2)Used By (0)

Laravel pagination
==================

[](#laravel-pagination)

Multiple `distinct(['field_a', 'field_b'])` with `paginate()`

Problem
-------

[](#problem)

- ORM select return error when calculate `total` rows for `pagination`

```
SomeModel::select(['*'])
    ->distinct(['field_a', 'field_b'])
    ->orderBy('field_a')
    ->orderBy('field_b')
    ->paginate($perPage)
```

- Exception example

```
SQLSTATE[42883]: Undefined function: 7 ERROR: function count(bigint, bigint) does not exist\nLINE 1: select count(distinct \"field_a\", \"field_b\") as aggregate from \"...\n
```

Install
-------

[](#install)

```
composer require larahook/distinct-on-pagination

```

Usage
-----

[](#usage)

- Add `DistinctOnPagination` trait in `SomeModel` class
- Pagination total must be calc without Exception

```
class SomeModel extends Model
{
    use DistinctOnPagination; //