Assistance Required to Retrieve Custom Table and Fields After Backout Operation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-21-2025 05:54 PM
I have created a custom application, and under that, I created an application menu and a table. I stored all the tasks I completed in an update set that I had created. After marking the update set as complete, I exported it as an XML file. Then, I accidentally clicked the Backout button, which led to the deletion of many records from my PDI. When I searched for the table I had created, I was unable to find it.
I then tried to undelete the records using the Deleted Records module. As a result, I can now see the table and some of its fields, with their action marked as INSERT OR UPDATE. However, in the Default Update Set (which is created automatically), the action for the table and fields is shown as DELETE. Apart from the backout operation, I never deleted any records manually. Additionally, I cannot find my table or its fields in the Deleted Records module.
Is there any way to retrieve my custom table and its fields?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-21-2025 08:50 PM - edited ‎01-21-2025 08:52 PM
Only tables that are audited will be tracked in deleted records module.
So if there are reference fields on table A from table B/table C and table A is configured for Audit and table B/C is not configured, then table B/C data can never be retrieved from the deleted records module. References will be gone.
More details on
Use the Deleted Records module to restore a deleted record
If the data is removed from Deleted records table(sys_audit_delete); the data can never be retrieved.
If it is PDI , then its a lost cause , if it is customer instance, then may be ServiceNow support can give some assistance, but still the above will apply i believe.
I hope this information helps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-28-2025 05:03 AM
I was able to retrieve my custom table using the following approach:
First, I navigated to the Default Update Set, where the table deletion was recorded. From there, I located the record corresponding to the deleted table and clicked on the Preview icon to open it. Then, I selected the Show Related Records related link.
At the top of the record, I found a Restore File UI action. By clicking this button, I successfully restored the table.
This method can be applied to restore other records as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-28-2025 05:08 AM
I was able to retrieve my custom table using the following approach:
First, I navigated to the Default Update Set, where the table deletion was recorded. From there, I located the record corresponding to the deleted table and clicked on the Preview icon to open it. Then, I selected the Show Related Records related link.
At the top of the record, I found a Restore File UI action. By clicking this button, I successfully restored the table.
This method can be applied to restore other records as well.