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


Hello,

 

I created a self-join relationship from table Account:

Table occurrence Account and table occurrence ParentAccount are connected

via Account::id = ParentAccount::id_Account

 

Example:

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:

 

Parent.png

 

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,

Mike

Outcomes