Findall In Relational Tables With != Condition

kruthika · December 19, 2012, 3:24pm

Hi all…

I have two tables jobStatus and notifiactionRules, structures of tables are:

JobStatus:

id : PK

name

notifiactionRules

id : PK

status_id : FK

i want to write a condition in findAll, such that i have to get the names of all job status that are NOT IN notifiactionRules.

I tried this:

$jobstatuslist = CHtml::listData(JobStatus::model()

            -&gt;findAll(array(


                 'condition'=&gt;'id&#33;=:status_id', 


                 'params'=&gt;array(':status_id'=&gt;NotificationRules::model()-&gt;findAll(),'id', 'job_status_id'))


			));

but i am getting error - Undefined offset: 2

can anyone pls help…

konapaz · December 20, 2012, 9:29am

Hi "reader"

check something like that

YourAR1::model()->findAll(array(

'condition' =&gt; YourAR2::model()-&gt;exists( 't1.id = t2.status_id')-&gt;findAll()

))

ragua · December 20, 2012, 9:57am

Hi,

you can also use SQL in findall, for instance in postgresql it would be something like




...::model()->findAll(array('condition'=> "not exists (select 'a' from notifiactionRules where notifiactionRules.status_id = JobStatus.id)"));

kruthika · December 20, 2012, 10:08am

Hi ragua,

Thanks alot… it works perfect… thanks again…

konapaz · December 20, 2012, 9:48pm

I misunderstood 'not exist ’ by ‘exists’ so ragua solution is the correct