Sign Up! | Tags | Domains | Statistics | Options | Advanced Search
|
Sign Up! | Tags | Domains | Statistics | Options | Advanced Search |
Tagged: tips, irc, activerecord
This question is asked quite a few times in #rubyonrails When your models look like : 1 2 3 4 5 6 7 class User < ActiveRecord::Base has_many :items end class Item < ActiveRecord::Base belongs_to :user end How do you find all the users with at least ‘n’ number of items ? Here’s how : User.find :all, :joins => " INNER JOIN items ON items.user_id = users.id " , :select => " users.*, count(items.id) … Continue Reading »