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

Gowrisankar Sat · ‎01-17-2018

The sysid stays, because those users are deleted before you made changes to the dictionary.

Chaitanya Chowd · ‎01-17-2018

Hi,

I have set the reference cascade rule to 'Clear', tried with different user added to GlideList field and then deleted the record. It is not working.

It's clearing the reference but not the sys_id.

Thanks & Regards,

Chaitanya

Gowrisankar Sat · ‎01-17-2018

Can you check if this happens for other users?

Chaitanya Chowd · ‎01-17-2018

a small doubt, users of servicenow or users in sys_user

Gowrisankar Sat · ‎01-17-2018

users in sys_user table