Why doesn't sorting by numeric field work in ActiveDataProvider?

Question

Yii

$dataProvider = new ActiveDataProvider([
      'query' => $query,
      'sort' => [
          'attributes' => ['id','name']
      ],
      'pagination' => [ 'pageSize' => 20 ]
    ]);

And in the form:

<?= GridView::widget([
  'dataProvider' => $dataProvider ...

As a result, sorting by name works, but not by ID. Actually, I tried with other numeric fields - it doesn’t sort numbers ... :(

Answer 1

Understood.
I messed it up :)
In the $query itself I did:
$query = Shops::find()->orderBy('name');

Answer 2

Good evening.
Try like this

'sort' => [
          'defaultOrder' => [
             'id' => SORT_DESC,
            'name' => SORT_DESC
           ]
      ],