AR and 'not in' statement

Archives Yii 1.0.x Discussions
1

Hi

I have:


SomeModel::model()->with('ins','reg')->findAll()

How can I get all these models, but where it’s id not in another models list

Can it be AR request, or need to use Command Builder?

2

Please clarify your problem:

  • do you mean you want NOT IN statement,

  • or do you mean you want only models that have related models?

3

something like


select * from a where a.id not in (select someid from <img src='http://www.yiiframework.com/forum/public/style_emoticons/default/cool.gif' class='bbc_emoticon' alt='B)' />

with AR

4

As it is very complicated, I firmly believe you have to handcode this query with command builder.

5

or it can be AR with left join and id not null in b table :)

6

Yes, but that won’t be the embedded sql you asked. :) Still, it is working. And nothing else matters.

7

could you give a code example how this could be done with AR?

thanks

8

i think it must be something like this, but in my case it does not work any ideas?


BsoType::model()->with(array('bsoRequest'=>array('condition'=>'??.id is null')))->findAll();
9 

BsoType::model()->with(array('bsoRequest'=>array('condition'=>'??.id is null')))->together()->findAll();

;)