Capture Deleted record in update set

[Sndeveloper Adm]

Hi, 

I would like to delete ONLY one record in DEV Which needs to be captured in update set. And eventually this record should be removed from QA and PROD as well. 

As deleted records are not captured in update sets, what is the best way to do this ?

TIA  

[Arun_S1]

@Sndeveloper Adm Please tell us which record you like to delete, are you talking about the code or data? and what is the reason for deletion.

I generally don't recommend deletion due to various reasons. In case if the record that is deleted is being referenced in a different table that will be broken and might behave incorrectly. If possible set the active flag of the record to false.

ServiceNow does not allow you to capture data changes (add/update/deletion) through an update set, instead you have to delete it manually.

Please mark the appropriate response as correct answer and helpful, This may help other community users to follow correct solution.

[Sndeveloper Adm]

@Arun_S1 

Thanks for replying,

Background is : we have record which is fetching from Third party data base.  This record  reference is deleted in that data base. so customer wanted to delete this in Service Now Database.

[Arun_S1]

@Sndeveloper Adm In that case you have navigate to the table list view, select and delete that record from the list view. This cant be captured as part of the update set.

If there are multiple records we can write a script for deletion but since this is a single record we can delete this from the list.

Please mark the appropriate response as correct answer and helpful, This may help other community users to follow correct solution.

[Sndeveloper Adm]

Yes I agree your point here.

Should we write a script to be captured in update set ? for one record which is deleted in DEV and to be captured in update set ?