1

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

SELECT Id, Title, FileType, ContentSize FROM ContentDocument ALLROWS WHERE isArchived = true
Improve this question
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, 2020 at 14:57

1 Answer 1

Reset to default
2

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.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .