Multiple conditions in relational query

Yii 1.1 General Discussion
1

I currently have this working relational query:


'phones2' => array(self::HAS_MANY, 'Phone', 'PartyId', 'condition'=>'phones2.PhoneTypeCode=:code',

  'params' => array(':code'=>'M')),

Now I want to add another condition based on another attribute. This is one of my failed attempts:


'phones2' => array(self::HAS_MANY, 'Phone', 'PartyId', 

  'condition'=>array('phones2.PhoneTypeCode=:code', 'phones2.IsObsolete=:iso'),

  'params' => array(':code'=>'M', ':iso'=>'N')),

How can I make this right?

2

You’re pretty close :)

The condition is actually the WHERE clause of the query, so it’s just plain ol’ SQL:




'phones2' => array(

  self::HAS_MANY, 'Phone', 'PartyId', 

  'condition' => 'phones2.PhoneTypeCode=:code AND phones2.IsObsolete=:iso',

  'params' => array(':code'=>'M', ':iso'=>'N')

),
3

Thanks ScallioXTX I was just coming back to post what you did. Thanks for the help.