Delete record in Multi Row variable set when unchecking the checkbox

[Sarah Austria]

Hi Guys,

I have a Requested For variable (itsm_requested_by), a checkbox (include_me_in_the_access) and a mrvs (users_who_need_access). When I checked the checkbox it will add the Requested For to the mrvs, then when deselecting the checkbox it should be remove from the mvrs.

I came across from one of the question  and was able to add the details in my mrvs by creating script include + client script (onChange)

Script Include:

var populateEmailfromList = Class.create();
populateEmailfromList .prototype = Object.extendsObject(AbstractAjaxProcessor, {

listcollector: function() {

var listValuename = [];
var userInfo = this.getParameter('sysparm_user_info');
var query = 'sys_idIN' + userInfo;
if(userInfo)
{
var gr = new GlideRecord('sys_user');
gr.addEncodedQuery(query);
gr.query();
if(gr.next()){

listValuename.push({
"name": gr.getUniqueValue('name'),
"ntid": gr.getValue('u_network_id')
});
}
}
gs.info('ARB JSON'+JSON.stringify(listValuename));
return JSON.stringify(listValuename);
},

type: 'populateEmailfromList '
});

OnChange Client Script:

function onChange(control, oldValue, newValue, isLoading) {
if (isLoading) {
return;
}

if(newValue == ''){
g_form.clearValue('users_who_need_access'); // give name of MRVS variable set here
}

if(oldValue != newValue){
var ga = new GlideAjax('populateEmailfromList');
ga.addParam('sysparm_name', 'listcollector');
ga.addParam('sysparm_user_info', g_form.getValue('itsm_requested_by')); // give here the requestor variable name
ga.getXML(listcolleValues);
}
function listcolleValues(response) {
var val = response.responseXML.documentElement.getAttribute("answer");

if (g_form.getValue('include_me_in_the_access') == 'true') {
g_form.setValue('users_who_need_access', val); // give name of MRVS variable set here
}
else if (g_form.getValue('include_me_in_the_access') == 'false'){

var toRemove = g_form.getDisplayValue('itsm_requested_by').value;
var finalArr = [];
var parser = JSON.parse(val);
for(var i=0;i<parser.length;i++){
var obj1 = parser[i];
var newParser = JSON.parse(JSON.stringify(obj1));
if(newParser.name != toRemove){
finalArr.push(obj1);
}
}
alert('new JSON' + JSON.stringify(finalArr));
g_form.setValue('users_who_need_access',JSON.stringify(finalArr));
}


}

}

Unfortunately, the "else if (g_form.getValue('include_me_in_the_access') == 'false'){" in my client script is not working for me. Please help me with my script. 

Appreciate for any assistance. 

thanks,

Sarah

[Sai Kumar B]

Hi @Sarah Austria 

If your onChange() client script is written on checkbox, then add below code 

if(newValue == 'true') {

//Do your logic to populate MRVS with Requested for info

} else {

g_form.clearValue('MRVSvariableName');

}

[Sarah Austria]

Thank Sai for the comment. 

However, this will clear all the details in the mrvs right? What I need is only to delete the record of the Requestor in the Requested By field.

[Ankur Bawiskar]

Hi,

since you need to remove the row if checkbox is unchecked; you would require onChange client script on checkbox

if it is false then do this

1) get the mrvs json string

2) iterate it and check if the name doesn't match; then push the row in array

3) once the iteration ends it would not have the user and then you can set the mrvs again

try this

else if (g_form.getValue('include_me_in_the_access').toString() == 'false'){

    var toRemove = g_form.getDisplayValue('itsm_requested_by').value;
    var finalArr = [];
    var parser = JSON.parse(val);
    for(var i=0;i<parser.length;i++){
        if(parser[i].name != toRemove){
            finalArr.push(parser[i]);
        }
    }
    alert('new JSON' + JSON.stringify(finalArr));
    g_form.setValue('users_who_need_access',JSON.stringify(finalArr));
}

Regards
Ankur

[Sarah Austria]

Hi Ankur, 

When I tried your script, it removes all in the list except my self, which should be the opposite one. 

Adding other users in the list.

the alert: 

after clicking ok in the alert: