How to create a Apex Trigger to reassign record ownership of Email-to-Case Attachment and Files to Case Owner?

Question

In our Org, Email-to-Case Attachments are also stored as Files. And that the default owner is an Admin. When a case with an attachment is reassigned to another user (non-admin), the attachment ownership is not reassigned. This causes a problem when the new Case owner tries to edit the details of the attachment/file. I got this Apex example but when I tried it, it didn't work. Appreciate any help and guidance on this problem.

trigger ReassignContentVersionOwner on ContentVersion (after insert) {
List<ContentVersion> versionsToUpdate = new List<ContentVersion>();
Set<Id> contentDocumentIds = new Set<Id>();

for (ContentVersion cv : Trigger.new) {
    contentDocumentIds.add(cv.ContentDocumentId);
}

Map<Id, ContentDocumentLink> docLinkMap = new Map<Id, ContentDocumentLink>([
    SELECT Id, ContentDocumentId, LinkedEntityId 
    FROM ContentDocumentLink 
    WHERE ContentDocumentId IN :contentDocumentIds 
    AND LinkedEntityId.Type = 'Case'
]);

Set<Id> caseIds = new Set<Id>();
for (ContentDocumentLink cdl : docLinkMap.values()) {
    caseIds.add(cdl.LinkedEntityId);
}

Map<Id, Case> caseMap = new Map<Id, Case>([SELECT Id, OwnerId FROM Case WHERE Id IN :caseIds]);

for (ContentVersion cv : Trigger.new) {
    ContentDocumentLink cdl = docLinkMap.get(cv.ContentDocumentId);
    if (cdl != null && caseMap.containsKey(cdl.LinkedEntityId)) {
        versionsToUpdate.add(new ContentVersion(
            Id = cv.Id,
            OwnerId = caseMap.get(cdl.LinkedEntityId).OwnerId
        ));
    }
}

if (!versionsToUpdate.isEmpty()) {
    update versionsToUpdate;
}

}

Answer 1

Looks like you are on the right track. One things that you need to check: Ensure that OwnerId can be updated on the ContentVersion. I did some modifications on your code. Please try this:

trigger ReassignContentVersionOwner on ContentVersion (after insert) {
List<ContentVersion> versionsToUpdate = new List<ContentVersion>();
Set<Id> contentDocumentIds = new Set<Id>();

for (ContentVersion cv : Trigger.new) {
    contentDocumentIds.add(cv.ContentDocumentId);
}

// Fetching ContentDocumentLinks linked to Cases
Map<Id, ContentDocumentLink> docLinkMap = new Map<Id, ContentDocumentLink>([
    SELECT Id, ContentDocumentId, LinkedEntityId 
    FROM ContentDocumentLink 
    WHERE ContentDocumentId IN :contentDocumentIds 
    AND LinkedEntityId IN (SELECT Id FROM Case)
]);

Set<Id> caseIds = new Set<Id>();
for (ContentDocumentLink cdl : docLinkMap.values()) {
    caseIds.add(cdl.LinkedEntityId);
}

// Fetching Cases with their Owners
Map<Id, Case> caseMap = new Map<Id, Case>([SELECT Id, OwnerId FROM Case WHERE Id IN :caseIds]);

for (ContentVersion cv : Trigger.new) {
    ContentDocumentLink cdl = docLinkMap.get(cv.ContentDocumentId);
    if (cdl != null && caseMap.containsKey(cdl.LinkedEntityId)) {
        //Changing the owner of the ContentVersion
        ContentVersion updatedVersion = new ContentVersion(
            Id = cv.Id,
            OwnerId = caseMap.get(cdl.LinkedEntityId).OwnerId
        );
        versionsToUpdate.add(updatedVersion);
    }
}

if (!versionsToUpdate.isEmpty()) {
    update versionsToUpdate;
}

}