I’m trying to build a list of accounts that do not have an SDR on the Account Team (AccountTeamMember)
Is there any way to query accounts that do not have a certain account team member role related to it?
I’ve tried a subquery where the TeamMemberRole does not contain ‘SDR’ but it isn’t working as I thought it would.
You are on the right track with a subquery condition. You need to filter Accounts where the AccountID is NOT IN the results of the subquery returned from the AccountTeamMember object.
I’ve done a similar thing with opportunities and line items in the example page attached below.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.