How to use CGridView with condition

Yii 1.1 General Discussion
1

the CGridview all the data,I don’t want to show all the data ,i want show some data with condition,like survey_id = 1,how can i do that?




<?php $this->widget('zii.widgets.grid.CGridView', array(

	'dataProvider'=>$dataProvider,

	'columns'=>array(

		'id',

		'survey_id',

		'name',

		'name_en',

		array(

			'class'=>'CButtonColumn',

		),

	),

)); ?>
2

You should do this with the data provider, not grid view:




$dataProvider=new CActiveDataProvider('ModelClass', array(

    'criteria'=>array(

         'condition'=>'....'

    ),

));
3

多谢了,qiang!

4

by the way ,how to show some data with condition in relation model when use CGridview?

5

That can be similarly done except that you also need to specify the ‘with’ option in the query criteria.

6

Does this also work with MANY_MANY relations?





$criteria = new CDbCriteria;

$criteria->with = array('categories') // categories is a MANY_MANY related model

$criteria->condition = array('categories = 54') // <-- want to display every ROW that has the category 54

is this possible to add some MANY_MANY intelligent logic to the CDbCriteria like this ? thank you !

7

Yesterday I asked about this on russian forum… but I didn’t heard any answers.

I solve this in… IMHO very ugly way.

I use some additional model attributes and handful of subqueries.

Currently I try to find more elegant solution

8
9

Thanks. Its works.

10

I think you should get a more extensive explanation. If still open to it please tell me