Ruby on Rails

Let's say I would use a scope. How could I do that? (let's ignore the "image_small" for now and focus on the subcategory) There is nothing in the product table that I can use to select the completed products. It is only regarded as completed if the related resellercategory is associated to a subcategory. So, in the scope I would need to join the resellercategories table and check if that is associated with a subcategory.

Feels a bit unnecessary to do that for a small thing as this. But maybe it won't affect the performance that much.

The other option I was thinking of was just to add an after_filter in resellercategory model like this:

  def update_products
    self.products.each(&:save)
  end

I'll see if I can get the scope to work first.

Regards
Linus