I have a data in which i have the employee name and the manager name.
I want to create a search where if someone select a name ( For Ex: John) it should return records where John is Manager Directly or Indirectly .
In below Example if i select John it should return all 3 records, Joy, Adam and Roy because Adam reports to John and Joy and Roy reports to Adam.
If i select Adam, it should only return 2 records, Joy and Roy.
Can someone please help, how can i do that ?