Skip to main content

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 件の回答
  1. 2025年4月2日 14:58

    Hi @Shay Rickles-McGreal

     

     

    Try it once, hope it  work 

     

    SELECT Id, ContentDocumentId FROM ContentVersion WHERE CreatedDate < LAST_N_DAYS:420 AND FileExtension = 'MP4'

     

    Thanks