[SalesForce] Case Email Attachments

I am trying to retrieve attachments for emails on a specific case using SOQL and not having much success. I am trying using following

Select id, Name, Body, ContentType, parentId from Attachment where parentId in (select (select id from EmailMessages) from Case where Id = '5005700001Oz5na')

I get unknown parsing error I guess because of the inner select statement. Can anyone point me in the right direction.

Best Answer

You can't use a sub-query in a Left Inner Join. If you want to get Attachment records looking up to EmailMessage records under a specific Case, you would use a direct query on EmailMessage in your join filter:

SELECT ... FROM Attachment WHERE ParentId IN (
    SELECT Id FROM EmailMessage WHERE ParentId = '5005700001Oz5na'
)

Related Solutions

[SalesForce] Trigger – update Case field based on FeedItem

I suggest code like this:

trigger MyTrigger on FeedItem (after insert) {
    List<Case> updates = new List<Case>();
    for (FeedItem fi : Trigger.new) {
        if (fi.ParentId.getSObjectType() == Case.SObjectType) {
            updates.add(new Case(
                    Id = fi.ParentId,
                    ??? = fi.???
                    ));
        }
    }
    update updates;
}

It checks that the FeedItem is related to a Case and uses the update pattern that does not involve a query.

Best Answer

Related Solutions

[SalesForce] Trigger – update Case field based on FeedItem

Related Topic