+ Start a Discussion
James Kacerguis 5James Kacerguis 5 

Query to find all accounts without contact with specific role

We use a contact role as designation for statement delivery.  I need to find all accounts that don't have a contact with a role set to statement delivery.  I can't think of how I would do this with a report. Is there a way I could do this with SOQL? 
MagulanDuraipandianMagulanDuraipandian
You can use Report for this.
Check https://www.infallibletechie.com/2019/12/how-to-find-accounts-with-specific.html for sample report.
James Kacerguis 5James Kacerguis 5
Thanks for the reply.  Contact Role is just a custom multi select picklist in our contact object.  Also, I'm not sure how I'd use the cross filter as I need all accounts that don't have a contact with a certain role.