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

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!




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.



- Bryan