CDbCriteria with relations?

windman · June 9, 2009, 12:16pm

Hi,

can I use relations building my query with CDbCriteria like this:



$criteria->condition = "myRelation.name = :name";


$critera->params = array(":name"=>'John');

?

qiang · June 9, 2009, 2:31pm

This should be fine. You just need to make sure the table alias is correct.

jazzypants · June 9, 2009, 5:49pm

Any luck getting this to work?

I'm trying the same thing with a many-to-many relation and I'm not having any luck.

My relation is defined as such:

'team'=>array(self::MANY_MANY, 'Team', 'TeamPlayer(teamId, playerId)'),

And my criteria is as follows:

$criteria = new CDbCriteria();

$criteria->condition = 'team.someCondition=:someCondition';

$criteria->params = array(':someCondition' => $someCondition);

When I execute the query, I get this:

CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'team.someCondition' in 'where clause'

Thoughts? Thanks in advance!

GoofyX · June 9, 2009, 9:30pm

You can turn on logging and see what's the generated SQL query, to see where the problem lies. I suspect a table alias naming issue…

jazzypants · June 10, 2009, 12:23am

Indeed, it was a table aliasing issue. I needed to define the alias name in my relation.

See this post for details…

Thanks again!