Sript to Remove Records created on a specific date

carlh · ‎07-28-2016

Can anyone provide a script to remove records created on a specific date?

Something went wrong today and we ended up with Duplicates of all records on our vendor table.

I need a script that will delete all records created on 7/28/2016 in Core_Company table.

Please let me know and thanks!

Pradeep Sharma · ‎07-28-2016

Hi Carl,

Slight modification to the script shared by Abhniay. Enclosed code in function and added setWorkflow line to turn of notification/BR

Script :

delCoreCompanyRec();

function delCoreCompanyRec()

{

var gr= new GlideRecord("core_company");

gr.addEncodedQuery("sys_created_onON2016-07-28@javascript:gs.dateGenerate('2016-07-28','start')@javascript:gs.dateGenerate('2016-07-28','end')");

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

gr.deleteMultiple();

}

View solution in original post

Abhinay Erra · ‎08-02-2016

Here you go. Copy this

delast_ContractRec();

function delast_ContractRec()

{

var gr= new GlideRecord("ast_contract");

var contract_query="sys_created_onON2016-08-02@javascript:gs.dateGenerate('2016-08-02','start')@javascript:gs.dateGenerate('2016-08-02','end')";

gr.addEncodedQuery(contract_query);

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

gr.deleteMultiple();

}

carlh · ‎08-02-2016

that was it!