deleting a record

Balakrishna Ko1 · ‎07-16-2017

I have to delete record that is selected in catalog form. so i have written code below in runscript activity in workflow. the record is not deleting from table only few times it is deleting. can anyone help me on this. thanks

script

var gr = new GlideRecord('u_training_courses');

//gr.addQuery('sys_id',current.variables.Requested_for);

gr.addQuery('active',true);

gr.query();

gr.next();

gr.deleteRecord();

antin_s · ‎07-22-2017

Hi Bala,

1. Field name - 'Requested_for' ('R' in caps). ServiceNow converts the field names to be smaller case by default. Need to change it as 'requested_for' or copy/paste the correct field name.

2. Field name to be queried with is 'group.name' and not 'group'. Make sure you are giving the correct group name (with correct case too).

Please try the below modified script.

var gr = new GlideRecord('sys_user_grmember');

gr.addQuery('group.name','itil_group');   //   group to group.name and make sure the group name is correct with right case

gr.addQuery('user',current.variables.requested_for); // change from Requested_for to requested_for

gr.query();

if(gr.next())

{

gr.deleteRecord();

}



gs.addInfoMessage("Testing " + current.variables.requested_for.getDisplayValue() + " removed");

Please try and share the message if it is not getting deleted.

Hope this helps. Mark the answer as correct/helpful based on impact.

Thanks

Antin

View solution in original post

antin_s · ‎07-22-2017

Also, try printing 'current', 'current.variables', and 'current.variables.requested_for' separately and make sure you are getting the expected values.

Hope this helps. Mark the answer as correct/helpful based on impact.

Thanks

Antin

Balakrishna Ko1 · ‎07-22-2017

Hi, Changed to current.variables.Requested_for" ....Working fine for the script.

Thanks all