How To Delete a record using Background Script

[Hari nadh]

How To Delete a record using Background Script?

[Jace Benson]

This is how;

https://developer.servicenow.com/dev.do#!/reference/api/paris/server_legacy/c_GlideRecordAPI#r_Glide...

var rec = new GlideRecord('incident');
rec.addQuery('active',false);
rec.query();
while (rec.next()) { 
 gs.print('Inactive incident ' + rec.number + ' deleted');
 rec.deleteRecord();
}

[Sibe]

@Jace Benson  What about when I want to delete on back end a selected record? 

[ramakrishna2204]

var inc = new GlideRecord('incident');

inc.addQuery('state','1');

inc.setLimit('1');

inc.query();

while (inc.next()) {

 inc.deleteRecord();

}

gs.print('incident number is ' + inc.number);

[Vaishnavi Lathk]

Hello @Hari nadh ,

Try this code

var grCmdbCiHardware = new GlideRecord('cmdb_ci_hardware');
grCmdbCiHardware.addEncodedQuery("serial_numberISEMPTY");
grCmdbCiHardware.deleteMultiple();

Make sure you give proper query.

To validate  the count and delete try this

var grCmdbCiHardware = new GlideRecord('cmdb_ci_hardware');
grCmdbCiHardware.addEncodedQuery("serial_numberISEMPTY");
grCmdbCiHardware.query();
gs.print(grCmdbCiHardware.getRowCount()); //check count before deleting
while(grCmdbCiHardware.next())
{
    //grCmdbCiHardware.deleteRecord(); //uncomment for delet
}

 Regards,

Vaishnavi Lathkar