[SalesForce] BeforeDelete Trigger on ContentDocumentLink object not firing

I have a trigger on ContentDocumentLink object. I have use case to show total number of Files and number of notes attached if the link was between Events and Content using Salesforce Content. And, offcourse, similar thing that needs to be done when a content is removed.

Code

trigger ContentDocumentLinkTrg on ContentDocumentLink (after insert, before delete)  
{
    //Check if customization is not enable through custom settings
    if(!CustomSettingsUtil.IsCustomizationEnabled())
    {
        return;
    }
    String BeforeOrAfter = (Trigger.isBefore ? 'Before' : 'After');
    String TriggerType = ''
        + (Trigger.isDelete ? 'Delete' : '')
        + (Trigger.isInsert ? 'Insert' : '');
    system.debug(BeforeOrAfter + ' ' + TriggerType);
    // run TriggerHandler
    new ContentDocumentLinkTriggerHandler().run();

}

Checking the debug log, it is entering the AfterInsert event but not BeforeDelete. I see no restrictions in the SF documentation, can anyone put some light on this, please.

Edit

I'm having this issue on Lightning while on SF-Classic this functionality is working fine.

Best Answer

I know this is quite late response, I totally forgot about this question. Anyhow, just updating this question so that if anyone does encounter such an issue, he/she may find solace.

I'm not sure if this is a bug or by-design, but when you delete a Content link between two objects in Salesforce Lightning, ContentDocumentLink trigger works fine but when a user delete the content in Salesforce Classic from the Files or Notes related list

file or note itself gets deleted
ContentDocumentLink is also not fired if user deletes the file/note through Chatter

I believed it should, as the File/Note is deleted its link also gets deleted but the trigger never fired. I logged a case with Salesforce but as usual technical I didn't get any helpful response.

So I implemented two more triggers to handle this

a trigger on ContentDocument object to handle deletion of Note/File itself.
a trigger on FeedItem object to handle content deletion from Chatter.

Error

delete Trigger.new;

Okay

delete [select id from merchant__c where id in :Trigger.new];

[SalesForce] Count of Files attached to Custom Object Record

public with sharing class ContentDocumentLinkTriggerHandler {
    
    public static void fileCount(Trigger.new){

        Set<Id> parentQuoteDocumentIds = new Set<Id>();

        for(ContentDocumentLink cdl : Trigger.new){

            parentQuoteDocumentIds.add(cdl.LinkedEntityId);

You may want to do some filtering here, probably on cdl.LinkedEntityId.Type, since you're only interested in parents that are SBQQ__QuoteDocument__c. Your current code silently works because of the way your query is structured, but if you start using this collection in other ways down the line, you may not remember that your collection could contain other Ids too and find unexpected behaviors.


        }

        List<SBQQ__QuoteDocument__c> quoteDocList = [SELECT Id FROM SBQQ__QuoteDocument__c WHERE Id IN :parentQuoteDocumentIds];

        for(SBQQ__QuoteDocument__c qd : quoteDocList){

            qd.Number_of_Files_Attached__c = quoteDocList.size();

        }

Here's the meat of it, and I think what you need here is to "rubber-duck debug" this code - explain it to a silent interlocutor out loud. Here's how I might narrate it:

"So here we query all of the SBQQ__QuoteDocument__c records from the trigger set. Then, we iterate over the Quote Documents, and for each one, we set the Number_of_Files_Attached__c for that Quote Document to the number of Quote Documents we found."

... There's the problem! The logic is not quite right here. You need an additional query on ContentDocumentLink to find the information you really want - the number of files attached to the Quote Document. You can do that here as a child subquery against the relationship ContentDocumentLinks:

List<SBQQ__QuoteDocument__c> quoteDocList = [SELECT Id, (SELECT Id FROM ContentDocumentLinks) FROM SBQQ__QuoteDocument__c WHERE Id IN :parentQuoteDocumentIds];

Then, iterate over the documents and set each one's Number_of_Files_Attached__c field to qd.ContentDocumentLinks.size().

And lastly, don't forget that you have to perform DML to persist these changes:

update quoteDocList;

Best Answer

Related Solutions

[SalesForce] Deleting records in an after trigger

Error

Okay

[SalesForce] Count of Files attached to Custom Object Record

Related Topic