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
--
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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
