Hi, I am currently trying to archive some files (ContentDocuments) and the tool I am using leverages SOQL for selection. These files are MP4 video files and the query keeps timing out unless I have some very tiny limit (like 5 or below). Is there anything I can do to stop the query from timing out? Here is the query below: SELECT Id FROM ContentDocument WHERE CreatedDate < LAST_N_DAYS: 420 AND FileExtension = 'MP4' I am using OwnArchive for reference and have tried using the 'boost' feature which also doesnt help.
3 respuestas
Try it once, hope it work
SELECT Id, ContentDocumentId FROM ContentVersion WHERE CreatedDate < LAST_N_DAYS:420 AND FileExtension = 'MP4'
Thanks