Hello,
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.
| _time | FirstName | Manager Name |
| 08th March | Joy | Adam |
| 07th March | Adam | John |
| 06th March | Roy | Adam |
Can someone please help, how can i do that ?
