how to clear the sys_ID

Chaitanya Chowd · ‎01-17-2018

Hi All,

Consider the below scenario and help me in solving it

I have created a "List" type field in Incident form and it is referenced to "User" table.

I added a user to the "List" type field in Incident form. After that. I deleted the same user in "User" table . Now i am able to see a sys_id in the "List" type field in Incident form.

So help me like, if i delete the a user in "User" table, it should also delete its value in the referenced fields("List" type field in Incident form) and it should not display any sys_id.

Shishir Srivast · ‎01-18-2018

Let's see if this helps,

(function executeRule(current, previous /*null when async*/) {

var userid = current.sys_id;

var useridlist = [];

var inc = new GlideRecord('incident');

inc.addQuery('u_user_list','CONTAINS',userid);

inc.query();

while(inc.next()){

var userlist = inc.getValue('u_user_list');

var users = userlist.split(",");

for(var i =0; i<users.length; i++){

if(userid.toString() != users[i].toString())

useridlist.push(users[i].toString());

}

inc.u_user_list = useridlist;

inc.update();

}

})(current, previous);

View solution in original post

SanjivMeher · ‎01-18-2018

Ok. As suggested by Shishir, you can use the script provided by him. It should be a Delete business rule on the table where you are deleting the record.

Please mark this response as correct or helpful if it assisted you with your question.