I want to get the Users which report to a particular user (A manager) by using the Hierarchical Relationship inside the User Object. Appreciate if someone can give an example.
How can I get the users from the Manager's point of view (What I need to do here is identify the users who are managers by looking at the availability of his/her child users via the Hierarchical Relationship (in my case field name is Planner__c) ). I have used the query like this. but it not working.
SELECT Name (SELECT Id,Name FROM Planner__r) FROM User