Find all children from related subtrees with ancestry gem

Question

I have a Site Model that has_ancestry. This model hierarchy has two trees....

TREE1

SiteA (Root)

TREE2

SiteC (Root)

Is there a method or SQL statement to show the link between SiteA and SiteD?

Or is this not possible given they exist on separate trees (associated via SiteC)?

I don't know ancestry per say, but you can try and have a look at this question, which describes your situation in a different frame. https://stackoverflow.com/questions/14518090/recursive-query-in-sql-server — ekampp, Aug 14 '18 at 20:42

score 0 · Answer 1 · answered Feb 22 '19 at 15:22

0

You can check with the while loop to go down to upwards and check until parent is nil.

answered Feb 22 '19 at 15:22

Ruby4Rails

Could you provide any preview example of how this loop would look like? – radrow Feb 22 '19 at 15:46
ancestry = SiteD.ancestry This provides parent,grandparent of SiteD which is (SiteC/SiteA) – Ruby4Rails Feb 22 '19 at 18:13

1 Answers1