As part of transformation program, we are sending data for certain tables to our reporting systems. One of the table is task_ci and we are facing a unique problem for which we are challenged on the platform functionality.
Scenario :
A record in task_ci can be deleted OOTB and there is no marker for against it apart from a record in the deleted records table.
The reporting system is not able to know if the record was deleted and they are asking for any markers from ServiceNow which is the data source.
We are unable to create a DB view in ServiceNow between Deleted Records and Task table due to sys_id present in payload.
Any thoughts on how this can be achieved since we are been questioned on the platform functionality and this basic feature of soft-delete not been present unlike many other enterprise tools.
