FuelPHP Forums

yoshin

Hi all,

How can I specify the order of 'order by' conditions including related fields?

Here is my code:

$results = Model_Article::query()

->related('author')

->order_by(

array(

'author.name'=>'ASC',

'category_id'=>'ASC',

)

->get();

I want to sort by author name first and then category_id. But the above code results the SQL like:

"ORDER BY `t0`.`category_id` ASC, `t1`.`name` ASC".

Is there any way to make the related table's field come before the main table's?

Harro

What version of FuelPHP are you on?

This issue was reported (https://github.com/fuel/orm/issues/134) and fixed about 2 months ago.

yoshin

You're right! Mine was 1.2. I should have checked on the latest version first.

Thanks!