CODEWITHSUNDEEP
ruby-on-rails
Tom Lehman
Tom Lehman

Reputation: 89193

Filtering results based on a many-to-many relationship

Posts belong to Users. Users have and belong to many roles (i.e., the tables we're dealing with here are posts, users, roles, and roles_users)

How can I select all posts written by a user who has the "Editor" role?

I.e., I want the database-driven version of

Post.all.select{|p| p.user.roles.map(&:name).include?("Editor")}}

Upvotes: 0

Views: 147

Answers (2)

Geoff Lanotte
Geoff Lanotte

Reputation: 7500

Post.all(:joins => {:user => :roles}, :conditions => ["roles.name = ?", "editor"])

Upvotes: 2

jigfox
jigfox

Reputation: 18185

You could try something like this:

class Role < ActiveRecord::Base
  has_and_belongs_to_many :users
  has_many :posts, :through => :users
end

Then you can do something like this:

Role.find(editor_id).posts

Upvotes: 2

Related Questions