How to delete a record from a reference table without deleting related records

MRAdmin
Tera Contributor

I am looking to clean up a reference table. The table holds records of employee names and gives access to the Service Catalog to submit requested items. There are employees listed in it that are no longer with the company that I'd like to delete. I am looking for the ability to delete these records but still have the names show up in the caller and affected user fields in incidents. I located the doc regarding Reference cascade rule (Advanced view) and you are supposed to be able to edit the rule and choose None in the Default field. This is the doc:

https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/data-dictionary-tables/reference/r_DictionaryEntryForm.html

I right clicked on the caller label in an incident and chose configure dictionary, then went to configure form design. 

Here is a screenshot of where the properties can be changed:

find_real_file.png

 

The employee's name was still removed from the field. I am thinking I am missing a step somewhere. Does anyone have any advice?

11 REPLIES 11

It is used to cascade the delete of child records.  For example without cascade when you deleted a REQ it would not delete the RITM or the SC Task records so you would have orphaned records with no parent.

MRAdmin
Tera Contributor

I am also noticing the the user profile is being deleted when I delete from this table. I suppose the sys_user record is being deleted but I'm not deleting from that table. Here is an example. There was a name in the caller field and now you see the sys_id in the watch list since the record has been deleted. 

find_real_file.png