Question about "ALL ROWS" in SOQL
It seems to me that the "ALL ROWS" keyword that you use in SOQL (to access records in the recycled bin) can only be used in Apex.
I went to Developer Console in the Query Editor and tried typing this
SELECT ID FROM Fruit__c
and it executes.
But If I add "ALL ROWS" at the end, i.e.
SELECT ID FROM Fruit__c ALL ROWS
then I got
"Unknown error parsing query" error.
If I write this in an Apex code, like this
List<Fruit__c> fruits = [SELECT ID FROM Fruit__c ALL ROWS];
then the line actually executes successfully.
It seems weird to me that "ALL ROWS" keyword cannot be used inside the Query Editor. Wondering if anyone has encountered that?