Get managers data from User table.

[Kush Sharma]

Guys - I have a requirement to create a report/dashboard to fetch user name with 4 levels of management.

Column names - User > Manager> Manager's manager> and so on till level 4

Pls help me with best possible solution.

Thanks

[Kush Sharma]

Hi Nayan @nayanawadhiya1 - We are not able to dot walkin in DB view.. Can you pls help

[nayanawadhiya1]

Hello Kush,

You can use joins on the database view like below and after that you can rename the label of those fields 

[Kush Sharma]

I tried this one but it only checks user manager not manager's manager ... 

[nayanawadhiya1]

You can add one more Join in it.

Above SS was just an example for requirement.

[Kush Sharma · Accepted solution]

I have implemented this solution with Remote table , thanks for your help and time