I am new to rails and stuck on one Querying issue. Here is the
situation.

Model: Category
class Category < ActiveRecord::Base
        has_and_belongs_to_many :postings
        has_and_belongs_to_many :volunteers
end

Model: Posting
class Posting < ActiveRecord::Base
        has_and_belongs_to_many :categories
end

Model: Volunteer
class Volunteer < ActiveRecord::Base
        has_and_belongs_to_many :categories
end

-------
Now Here is the problem I am trying to solve

I want to find out all the postings of the categories that the
volunteer is interested in. The volunteer might be interested in more
than one categories and posting might be assigned more than one
categories.

Here is the basic pseudocode

 vol=Volunteer.find 1
 vol_cats=vol.categories
foreach(vol_cat in vol_cats)
{
   postings=postings + vol_cat.postings
}


Thank you

-- 
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.

Reply via email to