You need to sign in to do that
Don't have an account?
SS Karthick
Get manager id based on user id
Hi folks,
Can anyone tell me the soql query getting manager id ??/
like user-->manager-->manager's manager and user1-->manager1-->manager of manager1
I wanna all managers id based on user
Thanks in advance
Karthick
Can anyone tell me the soql query getting manager id ??/
like user-->manager-->manager's manager and user1-->manager1-->manager of manager1
I wanna all managers id based on user
Thanks in advance
Karthick
String managerId = UserId;
while(managerId != null)
{
string managerId= [Select Id, ManagerId FROM User WHERE Id = :managerId].ManagerId;
if(managerId != null)
setManagerId.add(managerId);
}
Hope this helps!
Thanks
All Answers
Something like that, will give you the user manager ID and the managed users.
Select Id, Name, ManagerId, (Select Id, Name From ManagedUsers) From User
Thanks
String managerId = UserId;
while(managerId != null)
{
string managerId= [Select Id, ManagerId FROM User WHERE Id = :managerId].ManagerId;
if(managerId != null)
setManagerId.add(managerId);
}
Hope this helps!
Thanks
If I understood you question correctly,
can you try this,
SELECT Name, ManagerID, Manager.Name FROM User where id-:'id which is getting'
Mark this as best answer if its helps.
Thanks.
Praveen Murugesan
can you explain the scenario a brief like how to embed this code in a class.i am getting error like duplicate managerid and invalid managerid...
If you need to get all ManagerId related to that User you need to perform SOQL inside loop.
String managerId = UserId;
while(managerId != null)
{
string managerId= [Select Id, ManagerId FROM User WHERE Id = :managerId].ManagerId;
if(managerId != null)
setManagerId.add(managerId);
}
Hope this helps!
Thanks