Delete all records in a table script

carlh · ‎07-29-2016

Could you share a script to delete all records on the contract table and all records on the core_company VENDORs table? There are about 1200 contracts and 4210 vendors. We want to start over and load fresh data for testing

I saw the one on the wiki but was scared to try without asking the community

Thanks

Carl

Pradeep Sharma · ‎07-29-2016

Hi Carl,

Here you go.

For first task :

delCoreCompanyRec();   

function delCoreCompanyRec()   

{   

var gr= new GlideRecord("core_company");   

gr.addQuery('vendor', true);   

gr.setWorkflow(false); //Don't fire Business rule,notifications   

gr.deleteMultiple();   

}

For second task :

delContractRecords();   

function delContractRecords()   

{   

var gr= new GlideRecord("ast_contract");   

gr.query();

gr.setWorkflow(false); //Don't fire Business rule,notifications   

gr.deleteMultiple();   

}

Run the above script from Background-scripts.

View solution in original post

carlh · ‎07-29-2016

Pradeep with the steal!

Thanks abhi_r and agreenberg for your help as well!

Dinesh Kumar11 · ‎09-13-2018

Thanks its useful for me also.

Thanks,

Dinesh kumar

Tiago Duarte · ‎09-18-2023

Before using deleteMultiple() it's not a good practice to use the query() function (the deleteMultiple will do the query so you shouldn't use it in this case) 😉