CODEWITHSUNDEEP
sqlruby-on-railsrubyactiverecord
jcnnghm
jcnnghm

Reputation: 7432

Find records with more than one ActiveRecord HABTM Association

I've got two models, joined by a Has and Belongs To Many join table. Lets call these models User and Event. The majority of Users have 0 events, while few have one or more. I want to do something like:

User.find(:all, :joins => :events, :conditions => ["'Something that count the events' > ?"], 0)

The problem is, I'm not sure how to select only users that have 1 or more associated events.

Upvotes: 4

Views: 976

Answers (1)

jcnnghm
jcnnghm

Reputation: 7432

I've found the answer:

User.find(:all, :joins => :events, :select => 'DISTINCT `users`.*')

Basically, the users.* restricts the result set to just the users table, and the DISTINCT keyword makes sure each user is only returned once.

Upvotes: 4

Related Questions