report to get list of direct reports for a manager

Content

Hi Experts,

I am looking for a query where the manager can get the output as the name of all direct report specific to them, I am able to achieve it in analysis through the session variable, Could you please help to provide me the query so that I can use it in the table value set.

Requirement:

We have a requirement where we need to set up a field in the document of records in which managers can select the specific direct report from all the direct reports they have, for this, I am creating a table type value set for the DFF. I just need a query so that the specific manager will be able to see all the direct reports.