How to query only accounts that don't have attachments

Salesforce Asked by Akouayri Hamza on January 2, 2022

Use Case: get all accounts that don’t have a related attachment
I have used this query but I get an error when I add the Bold part

SELECT Id, (SELECT Id, StageName FROM Opportunities WHERE StageName = 'Closed Won'),(SELECT Title,ParentId FROM CombinedAttachments) FROM Account Where Id IN (SELECT AccountId FROM Opportunity WHERE StageName = 'Closed Won') AND ID NOT IN (SELECT ParentId FROM CombinedAttachments)

The bold part below throws the error shown in the image below

AND ID NOT IN (SELECT ParentId FROM CombinedAttachments)

apex data developer soql

One Answer

CombinedAttachments (note the plural) is the name of a relationship. CombinedAttachment is the name of the sObject.

You'd use the relationship name when performing a subquery. When you perform a semi-join in your WHERE clause, as in your bolded text here, you must use the actual sObject API name.

You've also got IN NOT instead of NOT IN, as was pointed out in the comments.

Answered by David Reed on January 2, 2022

How to query only accounts that don't have attachments

One Answer

Add your own answers!

Related Questions

Report delete option missing in salesforce lightning

Debug logs to identify UNABLE_TO_LOCK_ROW error

Lightning Web Component is not available in App Builder when deploying from VS code

Can not connect LWC and fullCalendar v5

Developer Console “Unpacking results” never finishes, even though log file indicates ready

Unable to use array.includes() with SSJS?

AMPScript IF statement or Loop?

Relationship between ContentVersion object and Document object

Unable to add records as multiple pills in visual force page

Remove Verification Code for one User

Allow community users to change own account information

What is wrong with this LIKE in an Query?

SOQL Aggregate functions circumventing limits?

trigger to validate price ranges

How to check a record is a new record or already created one

Can’t see global header in community

Update a field while changing stage in Kanban Lightning View

Best Practices for Testing Marketing Cloud Connect Integration

Lightning Datatable – Dynamically Hide actions for specific rows on the basis of data

How to get value on a custom field of child account as account name of parent of parent account?

Ask a Question