URGENT Need :- A choice was deleted in the production for one the field.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2023 03:36 AM - edited 04-27-2023 03:37 AM
Hi All,
Good Day !
A choice was deleted for one the filed in the production in process of re-labeling(Changed Very High choice to Critical) it due to that records with previous state(Very High) are appearing as empty now even though the re-labeled choice brought back to older version.
Could someone help me with the solution to recover the records which and all impacted due this and to bring state to previous version on the production.
Appreciate Quick help & thanks in advance !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2023 04:24 AM
Hi,
did you look in the "sys_audit_delete" table if the choice is there and can be restored?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2023 04:37 AM - edited 04-27-2023 04:38 AM
Many thanks for the response Sebastian , choice was restored already, but now my requirement is records was having this state(Choice in the field) value is now showing as empty, how to get records to place in their old state values.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2023 04:41 AM
if it doesn't happen automatically; you might require a fix script to update the state to that value.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2023 04:48 AM - edited 04-27-2023 04:53 AM
Thanks for the response @Ankur Bawiskar ,
if it is normal type of filed with choices I may easily achieve with fix script but Actually, the choices are coming as reference table of other table using advance reference qualifier, please find the attached.
Could you please give an idea and help how to fetch what records were with old value and bit logic related things for the script, can provide you details if required any.
