Ordering with eager loading


#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!


gallois
aka Felipe G.
blog: www.gallois.com.br/blog
fanglib homepage: www.gallois.com.br/fanglib


#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

On 19 Nov 2008, at 01:05, Felipe G. wrote:

is it possible or will i have to reorder it with ruby code?
:order => ‘teachers.something’

Fred


#4

On Wed, Nov 19, 2008 at 07:26, Frederick C.
removed_email_address@domain.invalidwrote:

it is associated with an id, and i want to order my result by the
thanks!

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

cheers!


gallois
aka Felipe G.
blog: www.gallois.com.br/blog
fanglib homepage: www.gallois.com.br/fanglib