Skip to main content

Include Deleted Clause

Salesforce allows you to include All Rows clause when you run the query in Apex language context. This clause shows all records, including deleted/archived records. This clause doesn't work outside of the Apex Language context.

Brobench supports similar clause include deleted, which runs the query SOQL to include deleted and archived records. option. This clause must come last after all other clauses, including any limit and offset clauses

Note that you can also query to show deleted records by executing the query using Execute with Include Deleted/Archived option. See Execute Other for more information.

For example.,

select Id, Name from Account
include deleted