AnsweredAssumed Answered

Using GTRR to extend a found set

Question asked by Polarpro on Mar 1, 2018
Latest reply on Mar 1, 2018 by Polarpro



I created a self-join relationship from table Account:

Table occurrence Account and table occurrence ParentAccount are connected

via Account::id = ParentAccount::id_Account



There is a record with id = 100 and id_Account = 105,

and there is a record with id = 105.

So, 105 is the parent of 100:




I can use the GTRR step to go to all the parent records of a found set.


However, at the same time I want that the child records are still in the found set. In other words: I want a found set that contains the records and their parent records.


Any idea how this can smoothly be done? :-)

Thank you,