what are the different ways to delete multiple records of a table at once with out script

Kevin68
Tera Expert

Hi

what are the different ways to delete multiple records of a table at once with out script

6 REPLIES 6

I am afraid there is no other way other then deleting manually using the old legacy way, through that you can delete 200 records based on your condition at max. But this will cause you a huge performance issue. 

Please mark my answer as correct and helpful if it helped you or resolved your query.

 

Thanks,
Mohit Kaushik
ServiceNow MVP (2023-2025)

Mohit Kaushik
Mega Sage
Mega Sage

Hi @Kevin68,

 

There are two ways you can do that,

1. Use Data Management option present in list view to delete multiple records with preview. It will allow you to select a condition for what all records you want to delete, and do you want to run the Business rules upon deletion or not. You can even select 'run at' in this option.

MohitKaushik_0-1671195752994.png

MohitKaushik_1-1671195837560.png

 

 

2. And then there is one legacy way, open the list view, show the list to 200 records in a page. Select the records you want to delete and click on delete from the list actions present at the bottom of the list. 
Note: Deleting multiple records without script by using above method will give you performance issue for sure, so running a fix script/background script would be a better option.

 

Please mark this as correct and helpful if your query is resolved.

 

 

Thanks,
Mohit Kaushik
ServiceNow MVP (2023-2025)