Yii Framework Forum: Not In Condition In $Criteria - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Not In Condition In $Criteria Rate Topic: -----

#1 User is offline   sefburhan 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 137
  • Joined: 08-February 12
  • Location:islamabad

Posted 18 March 2013 - 02:55 AM

How to use NOT IN in $criteria as i m trying to get result which is not in other table in search: like

incidents and statements
so in incidents in am trying to search all the statments which are not in statements table. the reverse is true using inner join but this is Not working... I have used select for it but it is not working with other filters!!!

Thanks
0

#2 User is offline   Maurizio Domba Cerin 

  • Yii - Yesss It Is !!!
  • Yii
  • Group: Yii Dev Team
  • Posts: 4,346
  • Joined: 12-October 09
  • Location:Croatia

Posted 18 March 2013 - 03:09 AM

Would addNotInCondition() help you?

http://www.yiiframew...ondition-detail
Find more about me.... btw. Do you know your WAN IP?
1

#3 User is offline   sefburhan 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 137
  • Joined: 08-February 12
  • Location:islamabad

Posted 18 March 2013 - 06:27 AM

thanks Maurizio Domba , A bit slow but works
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users