ordering with eager loading

rubyonrails-talk
1

I’m trying to order my results by what I got with eager loading.

there is a bit of code about what i want

@study_class = StudyClass.find(:all, :include => :teacher)

it is associated with an id, and i want to order my result by the teachers’ name, which is just inside the teacher table that is loaded there.

is it possible or will i have to reorder it with ruby code?

thanks!

2

is it possible or will i have to reorder it with ruby code?

Can be done like that:

@study_class = StudyClass.find(:all, :include => :teacher, :order => "teachers.name ASC")

(since :order takes pure SQL, it must be the table name in plural as used in the database)

3

I'm trying to order my results by what I got with eager loading.

there is a bit of code about what i want

@study_class = StudyClass.find(:all, :include => :teacher)

it is associated with an id, and i want to order my result by the
teachers' name, which is just inside the teacher table that is
loaded there.

is it possible or will i have to reorder it with ruby code?

:order => 'teachers.something'

Fred

4

perfect! worked like a charm! thank you very much guys!

cheers!