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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.