1

This soql is not retrieving any records, any issue in soql ?

SELECT Id, Title, FileType, ContentSize FROM ContentDocument ALLROWS WHERE isArchived = true
1
  • it seems like from documentation we are suppose to add ALLROWS at the end of the query try adding it at the end like SELECT Id, Title, FileType, ContentSize FROM ContentDocument WHERE isArchived = true ALLROWS – User6670 Feb 12 '20 at 14:57
1

Looking at the docs for ALL ROWS, you have to place it at the end of your query, and is 2 keywords. For it to work, update your query to:

SELECT Id, Title, FileType, ContentSize FROM ContentDocument WHERE isArchived = true ALL ROWS

Please note the query editor does not support an ALL ROWS query, so use anonymous apex to validate.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.