Ambiguous column name 'id' when sort attribute with relation

Yii 2.0 General Discussions
1

Hello everyone,

I have problem to sort attribute with relation model is show “Ambiguous column name ‘id’” .

I want to sort id of working model.




 $query = Model::find()->alias('t');

        

        $dataProvider = new ActiveDataProvider([

            'query' => $query,

            

        ]);

        $dataProvider->sort->defaultOrder = ['id' => SORT_DESC];

        

        $this->load($params);

        

        $query->joinWith([

            'relation1 AS r1',

            'relation2 AS r2'

        ]);

I try




['id' => SORT_DESC]; //not working

['t.id' => SORT_DESC]; //not working

how to? help me please…

2

Try this




$query = Model::find();

        

$dataProvider = new ActiveDataProvider([

	'query' => $query,

	

]);

$dataProvider->sort->defaultOrder = [Model::::tableName().'id' => SORT_DESC];


$this->load($params);


$query->joinWith([

	'relation1 AS r1',

	'relation2 AS r2'

]);
3

I try




$dataProvider->sort->defaultOrder = [Model::tableName().'.id' => SORT_DESC];

It still exception




Undefined index: table.id
4

What is your model name?

Please replace Model with your Model class name

5

Yes i try but it still exception

i used gridview with filter.

i’m not sure what is happen?

I used MS SQL Database.