acts_as_tree related question

rubyonrails-talk
1

hi, I've a normal Category model implemented with acts_as_tree (name, parent_id) that has_many :products (name, category_id).

What I'm asking for is a method to fetch every product that belongs fall into a particular category and its children, eg: if I'm asking for a root node (/category/show/1) I need to display every product that have category_id = 1 AND every product of the children categories.

After that I must paginate results, search, but that's really another story.

Somebody got an advice how to accomplish this?

thanks.

2

shai, thanks for your kind reply, yes, I've evaluated the use of tags for categorisation, but for now I really must stick with Category trees; I've also looked into acts_as_nested_set (and the better_nested_set one), but honestly I've found some difficulties to manage Category in this way.

what I really need is some input using acts_as_nested_set: eg. an example controller (to manage items) and the real problem: fetch every product in selected category and subcategories.

any hints on that?

thanks again.

claudio

3

what about #all_children in BNS

http://opensource.symetrie.com/api/better_nested_set/classes/SymetrieCom/Acts/NestedSet/InstanceMethods.html#M000023