[Jose H. Milán]

Is possible to do that?

public function scopes()
{
  return array(
   'completed'=>array(
	'join'=>'INNER JOIN jobs_role j1 ON j1.job_id = '.$this->tableAlias.'.id',
	'group' => $this->tableAlias.'.id',
    ),
   'drafted'=>array(
      'condition'=>$this->tableAlias.'.id NOT IN (SELECT jobjoin.id from jobs_job jobjoin INNER JOIN jobs_role rolejoin ON jobjoin.author_id = :ypl0 AND  rolejoin.job_id = jobjoin.id)',
      'group' => $this->tableAlias.'.id',
       ),
     );
}

I mean, could I use the ":ypl0" finder param directly in my subquery? The code works like a charm but... I think is not very orthodox. What others ways exists in yii to use this value in the subquery.

It is really strange I know. But this scope is only used to defined a relation in another model, so in need this :ypl0 (the id used in Where clause). Can I do in other way?

Thank you

[fr0d0z]

It's generally better to use $this->getTableAlias() so that you can pass in true/false values for its parameters. Depending on when you use your scopes, you can get ini finite loops if you aren't careful :-)

[Jose H. Milán]

fr0d0z, on 19 March 2013 - 12:47 AM, said:

It's generally better to use $this->getTableAlias() so that you can pass in true/false values for its parameters. Depending on when you use your scopes, you can get ini finite loops if you aren't careful :-)

Confused about that.

Is not the same to use $this->getTableAlias() and $this->tableAlias ? I guess it is totally the same if you don't need to specify any param...

About infinite loops in this case... I don't understand you, could you please give me and example?

Thanks

[fr0d0z]

Yes, they're the same if you don't specify parameters. I guess I was remembering the defaultScope aspect of this for looping issues, here's where the problem first came up:

http://www.yiiframew...ularly-crashes/

So, sorry and never mind :-)