SKYVVA offer CDC to help you record all your change data, which you have created on any business object and send out to the external system at any time. As of now, our CDC can be able to send the deleted records to the receiver as well. CDC executes the find/fetch record base on Salesforce’s query. With the SOQL query statement, you can fetch the deleted records in the recycle bin as well with “ALL ROWS”.
What are ALL ROWS? #
ALL ROWS is a keyword using to find or fetch the deleted records in the recycle bin. If you input this keyword in the SOQL statement, CDC will fetch both normal and deleted records. Only records inside the recycle bin will be fetched. Therefore, all the records that you empty from the recycle bin cannot be fetched at all.
for trigger after delete it is working when query selection with keyword ALL ROWS
E.g SELECT BillingCity,BillingCountry,Name,Id,Description From Account ALL ROWS
From the perspective of the receiver they don’t see the differences if the record is deleted or not. The deleted records are kept in the recycle bin. The purpose of sending deleted records is thatThey could need it because they want to make a reports on the receiving system “how many records has been deleted in the last few days”. They could want to be able to send deleted records which they still not empty from the recycle bin.