I've successfully sorting showed data in Yii2 gridview based on Id. Using $dataProvider
in controller:
$dataProvider->setSort([
'defaultOrder' => ['id' => SORT_DESC]
]);
But it also show data redundant, like this
__________________________
| Id | Name | City |
| 1 | Angela | Alabama |
| 2 | Brenda | Boston |
| 3 | Angela | Alabama |
how to set $dataProvider
so it avoid redundancy?
So the data in gridview will show like this:
__________________________
| Id | Name | City |
| 1 | Angela | Alabama |
| 2 | Brenda | Boston |
Thanks