My head is spinning a bit this morning - can somebody help me with this? Given these two models with the following associations:
class Article < ActiveRecord::Base belongs_to :category - has an attribute called "published_on" end class Category < ActiveRecord::Base has_many :articles end I need to list all categories, the order should be determined by the "published_on" date of their latest associated article. So for example: cat1 = Category.create cat1.articles.create(:published_on => 5.days.ago) cat1.articles.create(:published_on => 4.days.ago) cat2 = Category.create cat2.articles.create(:published_on => 2.days.ago) Then my list should be ordered: [cat2, cat1] I believe this would be trivial to make in raw SQL, but I have trouble figuring out, how to do it with AR's find() method. - Carsten -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---