Please help us find a solution for the following requirement.
Requirement : We are querying SuccessFactor for Compound Employee data and need to find out the VP of the Employee by finding his/her leadership group with a certain values and if he/she is not a VP then we have to find his/her Manager and get the Manager's data. Then find Manager's leadership group with the given values and if he/she does not fall under VP category then find out his/her Manager and then fetch his/her data.
Repeat this process until we find the VP of an Employee and send it out.
We are trying to achieve this by querying the data from SuccessFactor and storing it in a Document Cache.
After this we are clueless on how to proceed further to search every hierarchy for VP.
Thanks & Regards