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
    Commented Feb 12, 2020 at 14:57

1 Answer 1

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.

You must log in to answer this question.

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