+ Start a Discussion
Soundar Raj PonpandiSoundar Raj Ponpandi 

Change this code for list of records update

Hi,

Can you please help me to update with bulkify of this coding.
 
ContentDocumentLink exFile=[SELECT Id, LinkedEntityId, ContentDocumentId, Visibility, IsDeleted, ShareType FROM ContentDocumentLink WHERE LinkedEntityId =: request.get(0).id];
                ContentDocumentLink newFile= exFile.clone();
                newFile.LinkedEntityId = con.id;
                
                insert newFile;
                delete exFile;

Thanks in Advance ,
Soundar.
Best Answer chosen by Soundar Raj Ponpandi
Abhishek BansalAbhishek Bansal
Hi Soundar,

Please find the code below:
List<ContentDocumentLink> insertList = new List<ContentDocumentLink>();
List<ContentDocumentLink> deleteList = new List<ContentDocumentLink>();
ContentDocumentLink newFile;
for(ContentDocumentLink exFile : [SELECT Id, LinkedEntityId, ContentDocumentId, Visibility, IsDeleted, ShareType FROM ContentDocumentLink WHERE LinkedEntityId =: request.get(0).id]){
	newFile = new ContentDocumentLink();
	newFile= exFile.clone();
	newFile.LinkedEntityId = con.id;
    insertList.add(newFile);
	deleteList.add(exFile);
}
if(insertList.size() > 0) {
	insert insertList;
}
if(deleteList.size() > 0) {
	delete deleteList;
}

Please take care of the syntax errors and let me know if you need any other help on this.

Thanks,
Abhishek Bansal.

All Answers

Abhishek BansalAbhishek Bansal
Hi Soundar,

Please find the code below:
List<ContentDocumentLink> insertList = new List<ContentDocumentLink>();
List<ContentDocumentLink> deleteList = new List<ContentDocumentLink>();
ContentDocumentLink newFile;
for(ContentDocumentLink exFile : [SELECT Id, LinkedEntityId, ContentDocumentId, Visibility, IsDeleted, ShareType FROM ContentDocumentLink WHERE LinkedEntityId =: request.get(0).id]){
	newFile = new ContentDocumentLink();
	newFile= exFile.clone();
	newFile.LinkedEntityId = con.id;
    insertList.add(newFile);
	deleteList.add(exFile);
}
if(insertList.size() > 0) {
	insert insertList;
}
if(deleteList.size() > 0) {
	delete deleteList;
}

Please take care of the syntax errors and let me know if you need any other help on this.

Thanks,
Abhishek Bansal.
This was selected as the best answer
Soundar Raj PonpandiSoundar Raj Ponpandi
Thanks Abhishek,

This code is working perfectly.

Regards,
Soundar.