I'm working on a search, order and paginate option for my project and this all works ok. But i have a one question.
Is it possible to order on a field from a related model?
For example: i have an object called Robot, and each robot has one Manufacturer, they are related with IDs, is there a way to sort on the manufacturers name with use of Robos::find() ?
Robots::find(array('order', 'manufacturername DESC'));
I can't find anything in the documentation or on the forum about this. I know i can do this with raw SQL queries and joining the manufacturer table but i would like to avoid that.
Thanks in advance!