I'm implementing a custom view on deleted items (I'm making a 'Recycle Bin' type view for all objects of 1 type, regardless of who deleted them). So far, I'm getting the deleted items with SOQL with ALL ROWS. However, I'd like to be able to do text search on these records. Is there a way to do that? In other words, is there an equivalent to 'ALL ROWS' for SOSL?
It appears in the docs that there is no such feature. The topic on the
RETURNING keyword lists all the allowed SOQL-like keywords, and `ALL ROWS is not in there.
SOSL is using a full-text-search index as its primary means of finding results. For efficiency, I would expect that we purge that index on "delete" of the record. Why keep all the extra dross of deleted data in the index, it would just confuse the search algorithms, slow down the search, reduce efficiency, etc.
A little test of trying to use
ALL ROWS in the developer console bears out the "it don't work" as I get a malformed query error.