grandgrand grandparent grandparent parent child relationship

swiftinitpvtltd

If I have a BO with products which are related to each other via grandgrand grandparent grandparent parents child relationship how do I query them? There is a reference post but it only talks about this/that/other but not recursive.

So
1 grandgrand parent product
3 grand product
1 2 3

Each grand product having 2 or 3 child product

and each child can have multiple children products with relationship using ID setup as who is child column in Products BO.
If I try Find Product where Product =ThisProduct.whoischildren in batches of 1 (I may get 4 children or 7 or 8-)
after 2 loops it quickly goes wrong with this/that/other product mess...
How do I go deep inside this recursively...

https://forum.awareim.com/https://forum.awareim.com/d/9954>

customaware

I assume you mean something like this....?

If so,

GrandParentBO
om_ParentBO (many)

ParentBO
ob_GrandParentBO (one)
om_ChildBO (many)

ChildBO
ob_ParentBO (one)
om_GrandChildBO (many)

GrandChildBO
ob_ChildBO

If this is what you mean, there are a number of ways to approach it.

If using full pathing for example...

Example 1: I want ALL GrandChild of a Particular Parent (when we know the Parent)

FIND GrandChildBO WHERE GrandChildBO.ob_ChildBO.ob_ParentBO=ParentBO

Example 2: Similarly I want ALL ChildBO of a Particular GrandParent (when we know the GrandParent)

FIND ChildBO WHERE ChildBO.ob_ParentBO.ob_GrandParentBO=GrandParentBO

You can shorten it up with Shortcuts which is SOMETIMES easier.

Add a Shortcut in GrandChildBO called sc_GrandParent defined as ob_ChildBO.ob_ParentBO.ob_GrandParentBO

Hence, Example 3: Find ALL GrandChildBO or a known GrandParent becomes

FIND GrandChildBO WHERE GrandChildBO.sc_GrandParent=GrandParent

You should not need to do any of this stuff with the ID attribute.

Rely on the correct references.

If this does not help, send me a clearer and more detailed example (I like pictures) and I will try and help.

swiftinitpvtltd

Thanks Mark! I will give it a try. Many times I want to go 10 levels deep or 20 level deep based on depth of that chain. For example for one person I want to find grand grand... grand parent from 12th century.

Greatest Grand parent from 12th century

....13th 10 people

....14th 20 people

20th century persons- 2 kids

So the level of recursive depth is completely dynamic based on chain(for example one product can have 10 level deep relationships, another just 6-just like someone ancestry can go just till 19th century while someone else can go 800 years back with many many grand grand grand parents)