function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Ethan_LoEthan_Lo 

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

Best Answer chosen by Admin (Salesforce Developers) 
shillyershillyer

It's essentially a lookup to another user, this should work:

 

Select ManagerId From User

 

Hope that helps,

Sati

All Answers

shillyershillyer

It's essentially a lookup to another user, this should work:

 

Select ManagerId From User

 

Hope that helps,

Sati

This was selected as the best answer
Ethan_LoEthan_Lo

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'.   

JimRaeJimRae

There is a managerID field on the user record, maybe the profile you are using does not have visibility to it?

 

shillyershillyer

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

Message Edited by shillyer on 03-26-2009 02:04 PM
Ethan_LoEthan_Lo

Bingo!!! The problem is that the tool Apex Explorer 8.0 that I'm using is using an older API.

BrianW4123BrianW4123

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