We're creating a system that fetches records from the database. The user of our system wants that item to be deleted in the item page for example so once that item has been deleted in the database, it will also disconnect that record in the foreign key from the parent record. Although we can still see the deleted record in the logs or using $deleted from dAPI, filtering them out and reconnecting to the foreign key from parent record is a difficult task to achieve in fact that we are using this for special cases such as monthly reports.

The business goal is, even if the record has been deleted from the database, it can still fetch the data (deleted record) from the specific foreign key.