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

Abhinay Erra · ‎07-29-2016

You want to delete all the records in ast_contract and core_company table?

carlh · ‎07-29-2016

Yes

Just vendors = true on core company but all contracts

Get Outlook for iOS<https://aka.ms/o0ukef>

Abhinay Erra · ‎07-29-2016

I am about to post the script, but looks like you have enough responses. I missed points on this one

Pradeep Sharma · ‎07-29-2016

@carl,

On your next thread please tag me as well