You need to sign in to do that
Don't have an account?
Where is the Manager Field in User Table?
I am trying to use salesforce.com data to generate some SQL Server Reporting Service reports. So the first step is to pull data out of salesforce.com and import that into my company's own Microsoft SQL server database. I am in the process of defining the field mappings.
Since I am trying to make a "manager sales report". When I logged into Salesforce.com, I see that the user setup screen has a field "Manager" right under "Delegated Approver". So then use the free tool Apex Explorer to look at the User table. I cannot find any field Manager or anything that would allow to join to get that info. Help me please!
Ethan
It's essentially a lookup to another user, this should work:
Select ManagerId From User
Hope that helps,
Sati
All Answers
It's essentially a lookup to another user, this should work:
Select ManagerId From User
Hope that helps,
Sati
That didn't work. There's no such field called "ManagerId" in the User table.
When I ran that SOAL statement in Apex Explorer, I got the following error.
Query failed: INVALID_FIELD:
Select ManagerId From User
^
ERROR at Row:1:Column:8
No such column 'ManagerId' on entity 'User'.
There is a managerID field on the user record, maybe the profile you are using does not have visibility to it?
You are connecting to an old version of the API. Change your endpoint in Options to:
https://www.salesforce.com/services/Soap/u/15.0
Hope that helps,
Sati
Bingo!!! The problem is that the tool Apex Explorer 8.0 that I'm using is using an older API.
Does anyone know how to access the managerid field using the Crystal Reports driver for salesforce.com?
It looks like it must be using an older version of the API.
Thanks,
Brian