Deleting a child record GlideRecord

reginabautista · ‎09-12-2016

Hi everyone, I'm quite new in ServiceNow so still learning.

I have a Business Rule that deletes child records from a parent table. I have added the code below but for some reason it wouldn't delete the entries. I'm probably missing something here..Any ideas?

var gr = new GlideRecord('table name');

gr.addQuery('u_parent', current.sys_id);

while (gr.next()) {

gr.deleteRecord();

}

Abhinay Erra · ‎09-12-2016

You are missing gr.query() here. Use this script and you are good to go

var gr = new GlideRecord('table name');

gr.addQuery('u_parent', current.sys_id);

gr.query();

while (gr.next()) {

gr.deleteRecord();

}

You can also use this to delete multiple records

var gr = new GlideRecord('table name');

gr.addQuery('u_parent', current.sys_id);

gr.deleteMultiple();

View solution in original post

veena_kvkk88 · ‎09-12-2016

Ow! missed that! My points!

Abhinay Erra · ‎09-12-2016

Glad you got your question answered.