Bug in Yii2 - pagination doesn't work with orderBy()?

Question

Yii

The documentation provides a very good example of how to work with pagination
. However, as soon as you set it, the calculation starts to fail. And it is buggy in this way - on some page it will display 15, on some 14. At the same time, the pageSize parameter is set to 15. But if you remove orderBy(), then everything works perfectly. It seems that I am not the first one who encountered this, but I could not find an adequate solution anywhere so far.orderBy('id DESC')

$query = Article::find()->where(['status' => 1])
                                   ->orderBy('id DESC');

Does anyone have a solution maybe?

Answer 1

The solution turned out to be quite trivial, you need to put groupBy() on the same column before orderBy().

$query->groupBy('items.id')
           ->orderBy('items.id DESC');

It is strange that the developers did not mention this in the documentation.

Answer 2

try adding orderBy after pagination, like this:

use yii\data\Pagination;

$query = Article::find()->where(['status' => 1]);
$count = $query->count();
$pagination = new Pagination(['totalCount' => $count]);

$articles = $query->orderBy('id DESC')->offset($pagination->offset)
    ->limit($pagination->limit)
    ->all();

Answer 3

Try like this
orderBy(['id' => SORT_DESC]);

Answer 4

If you use ActiveDataProvider, then sorting must be set in it, and not in query