Active Record Querying-Help

Rails
1

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

2

On 11 June 2012 16:03, sigdelsaroj [email protected] wrote:

class Posting < ActiveRecord::Base

{
postings=postings + vol_cat.postings
}

Is that not the same problem you posted a few days ago, and then
posted the solution?

Colin