Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
BGrimesBGrimes 

Query Account Teams?

Hi -

 

I have a question on something that I've done in the past, but can't recall how I did it.  I need to query account teams, to pull a list of all people of a certain role and their access to the case object.  

 

The hitch here is that the AccountTeamMember table is just the Account access.  Ok.  So then I go to the UserAccountTeamRole table and see that the columns are there that I want, UserId and CaseAccessLevel.  Super!

 

But

 

When I query that table via SQL or Apex Explorer I only get 148 UserAccountTeamMember records returned.  That's like 1% of the account team data.  Am I just missing something?

 

I think in the past I was able to pull the team role data using te UserId as the Key between AcccountTeamMember and UserAccountTeamMember with no problem.  But now I get 1% of the access data for some reason.

 

Has anyone else done this before?  I'm missing something, and of cource Salesforce doesn't support anything regarding what I'm trying to do.

 

Thanks 

- Bryan