how to use relation table when using sqldataprovider

Question

please help I dont know how to get relation table when using sqldataprovider. Anyone understand how to use relation model?

$model = new Finalresult();
$searchModel = new FinalresultSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);

$dataProvider = new SqlDataProvider([
   'sql' => 'SELECT finalresult.bib,
            finalresult.series_id,
            finalresult.category_id,
            GROUP_CONCAT(DISTINCT finalresult.point ORDER BY series.serie_seri_no DESC) AS seriPoint 
            FROM finalresult, series GROUP BY finalresult.bib',
    'key' => 'bib',
]);

I'm trying to get relation table:

'attribute'=>'category_id', 
'width'=>'300px',
'value'=>function ($model, $key, $index, $widget) { 
     return $model->category->category_name;
},

then getting trying to non-object

show FinalResult model. it's a gridview or detailView? — Insane Skull
– Insane Skull, Commented Jan 25, 2016 at 4:42

arogachev · Accepted Answer · 2016-01-25 04:58:38Z

2

You can't use relations with SqlDataProvider, because each single result will be presented as array, for example:

[
    'id' => 1,
    'name' => 'Some name',
    'category_id' => 1,
],

For example, you can access category_id as `$model['category_id'].

SqlDataProvider is for very very complex queries, your query can easily be written as ActiveQuery and you can use ActiveDataProvider and get all advantages of that (relations, etc.).

You can find category by id, but it will be lazily loaded that means amount of queries is multiplied by number of rows.

With ActiveDataProvider and relations you can use eager loading and reduce amount of queries. Read more in official docs.

edited Jan 25, 2016 at 4:58

answered Jan 25, 2016 at 4:44

arogachev

33.6k8 gold badges119 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hanafi · Accepted Answer · 2016-01-25 04:52:25Z

0

Grid Columns example in documentation

try to change "value" to

'value'=> function($data) { 
     return $data['category']['category_name'];
}

answered Jan 25, 2016 at 4:52

Hanafi

1516 bronze badges

Collectives™ on Stack Overflow

how to use relation table when using sqldataprovider

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related