Sorting by a field of an associated class

Rails
1

I feel like i should know this but i’ve got the lurgy and am feeling a
bit dumb…

If a User belongs_to a Company, how do i find a list of users, ordered
by user.company.name?

thanks
max

2

You can write a method like following in the user.rb

def <=>(user)
self.company.name <=> user.company.name
end

and use the sort method of array to sort the users. for example,
users.sort

3

If you are using user.find method then use the following symbols in the
find method :include => ‘company’ :order => ‘company.name’

4

Ayyanar Aswathaman wrote:

If you are using user.find method then use the following symbols in the
find method :include => ‘company’ :order => ‘company.name’

nice one, thanks!

5

Max W. wrote:

Ayyanar Aswathaman wrote:

If you are using user.find method then use the following symbols in the
find method :include => ‘company’ :order => ‘company.name’

nice one, thanks!

Actually to get this to work i had to change the value of :order to
:order => ‘companies.name’, ie to match the name of the db table.

6

Max :

Actually to get this to work i had to change the value of :order to
:order => ‘companies.name’, ie to match the name of the db table.

You can use :order => “#{Company.table_name}.name”
to avoid thinking about the real (eventually legacy) name of the db
table.

– Jean-François.

7

Jean-François Trân wrote:

Max :

Actually to get this to work i had to change the value of :order to
:order => ‘companies.name’, ie to match the name of the db table.

You can use :order => “#{Company.table_name}.name”
to avoid thinking about the real (eventually legacy) name of the db
table.

– Jean-Fran�ois.

Thanks - that will be useful in few situations actually :slight_smile: