find objects in many_to_many (:through) relation

rubyonrails-talk
1

Hi, my first question, and probably a newbish one:

So I have a projects model, which belongs to a user :through an assignment table...

like this:

class User   has_many :assignments   has_many :projects, :through => :assignments end

class Project   has_many :assignments   has_many :users, :through => :assignments end

class Assignment   belongs_to :user   belongs_to :project end

Now I want in the startpage (home controller), after logging in, see all the projects assigned to the current user.

How do I wwrite that query?

I have assignments like

@assignments = Assignment.where("user_id = ?", current_user.id)

but if I try the same thing with projects I get an error.... as there is no user_id column in projects..

there must be an elegant way to query this with Active Record, right?

thanks in advance

2

You wouldn't normally use where (or find in previous versions of rails) for this sort of stuff. Setting up associations with has_many etc. means you can do current_user.assignments, current_user.projects etc.

Fred