default condition in a model

jkofsky · December 16, 2010, 9:43pm

I have field in my Employees table called ‘IsActive’. I want to use it to list only the Active Employees in EVERY listing of Employees. Something like:

‘defaultCondition’=>‘IsActive=1’;

Thanks

rymonator · December 16, 2010, 9:50pm

In your model’s search function add:


$criteria->compare('isActive',1);

That works at least for actions that use $model = new Employees(‘search’), like the default admin page which uses that for its CGridView.

jkofsky · December 16, 2010, 10:00pm

rymonator:

In your model’s search function add:
$criteria->compare('isActive',1);
That works at least for actions that use $model = new Employees(‘search’), like the default admin page which uses that for its CGridView.

Thanks. I tried that but when I comment out that line in the actionIndex function that I have a new CDbCriteria created, it didn’t work in that page.

mikl · December 17, 2010, 9:01am

Read the section about "Default Named Scope" here:

http://www.yiiframework.com/doc/guide/1.1/en/database.ar#named-scopes

jkofsky · December 17, 2010, 6:44pm

Thank You Setting up the defaultScope did the trick.

Sometimes the docs really help but for us newbies, there’s soooooo much that one doesn’t really know what to look for (filter, scope, etc) in order to be able to look for it…Oh well, Thanks again.

jacmoe · December 17, 2010, 7:44pm

That’s what the forum is for…