yii2 dataProvider- offset in dataprovider doesn't work

Question

Offset is not working- is it correct? The pagination doesn't work.

$query = Event::find()
            ->offset(4)
            ->groupBy("sort_today");

        $dataProvider = new ActiveDataProvider([
            'query' => $query,
        ]);

Answer 1

If you want to set offset manually you need to switch off the pagination.

$dataProvider = new ActiveDataProvider([
    'query' => $query,
    'pagination' => false
]);

Otherwise pagination resets offset to whatever page is current.