Criteria object, JOINS and ambigious column names

Archives Yii 1.0.x Discussions
1

If i create/set a criteria object doing a join between two tables, and properly aliasing ambigious column names in the select clause, and then i applied the criteria like this:



MyModelClass::model()->findAll($criteria);

in the resulting model objects i don't have properties named based on my column aliasing i did in the select clause. I only have base model attributes

2

Did you try adding with() before calling findAll()?

3

Quote

Did you try adding with() before calling findAll()?
i don't see the reason why to add the with() method...i mean the query i make with the criteria object is already a complete right join and the result is right (i see the result applying the query directly to the database), but the problem is that i don't get the properly aliased columns i made in that query in the resulting active record object
4

Sorry, I suggested with() because you mentioned you only have base model attributes, so I thought maybe the from clause is the source of this problem.

If you create a fully unique query, it’d be a better idea to run it via dbConnection->createCommand()->query(), as CActiveRecord might not handle custom result sets. I firmly believe that CDbDataReader is independent from any table scheme.

5

i would like to hear qiang on this…maybe this could be a little bug?

6

You need to declare public member variables which are named as those extra columns being selected.

7

Quote

You need to declare public member variables which are named as those extra columns being selected.
mm..is this the best way to do this? or in this situation it is better to do it with createCommand()->query() ?
8

Maybe. The way you are using criteria like this (joining other tables and populating the main model with the query result) does not follow very well the AR model.