Re: [Rails] belongs_to and order

On Dec 9, 2011, at 2:28 PM, Fresh Mix wrote:

> Two tables:
> Users (id, username)
> Books (id, name, user_id)
>
> User has_many :books
> and
> Book belongs_to :user
>
> How can I order Books by username?
>
> @books = Book.all.order(user.username) ????

@books = Book.includes(:user).order('users.username').all

-or-

@books = Book.includes(:user).all.sort_by {|book| book.user.username }

the first gets the database to return the books in the username order

The second gets the books as ruby objects, then uses the sort_by method to do the ordering.

-Rob

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.