To check checkboxes based on field values

[Poorva Bhawsar]

Hi Community,

When user selects some variables values as approved from the dropdowns on catalog task, i want to check some checkboxes on the cmdb_ci form.

For e.g., if xyz is selected as approved from the dropdown list, then it should check xyz checkbox on the cmdb_ci form before closing the request.

Thanks

[Poorva Bhawsar]

my code is same. But still its not working.

[Aniket Chavan]

Hello @Poorva Bhawsar 

I have provided you the code with added logs inside so did you checked the logs? and at what point the code is not working? are you able to get the variable values in the logs?

[Anil Lande]

Did you add additional logs to debug provided script?

Which loop it is going and what values you are getting?

Also share all your variable names and types.

If possible screenshots.

[Anil Lande]

Hi,

Please use below:

if (current.variables.oat_type == 'Server') {
    gs.info('Inside Server condition');
    var server_name = current.variables.server_name_s;
    var grCI = new GlideRecord('cmdb_ci');
    grCI.addEncodedQuery('sys_idIN' + server_name.toString());
    grCI.query();
    while (grCI.next()) {
        if (current.variables.server_privilaged_account_onboarded_to_piam == 'accept') {
            grCI.u_tpam == true;
        }
        if (current.variables.database_onboarded_to_siem_confirmation_approval == 'accept') {
            grCI.u_siem == true;
        }
        if (current.variables.cis_scan_nessus_scan_passed_confirmation_approval == 'accept') {
            grCI.u_nessus == true;
        }
        if (current.variables.ds_am_av_and_network_protect_with_ips_policy_is_set_to_prevent_or_ms_defender_installed == 'accept') {
            grCI.u_av_am_ips == true;
            grCI.u_xdr == true;
        }
        grCI.update();
    }
} else if (current.variables.oat_type == 'Database') {

    var server = [];
    var mrvsParsed = JSON.parse(current.variables.mrvs_contain_server_name.toString()); // use MultiRow Variable set backend name here
    for (var x in mrvsParsed) {
        server.push(mrvsParsed[x].server_name.toString());
    }

    var gr1 = new GlideRecord('cmdb_ci');
    gr1.addEncodedQuery('sys_idIN' + server);
    gr1.query();
    while (gr1.next()) {
        if (current.variables.server_privilaged_account_onboarded_to_piam == 'accept') {
            gr1.u_tpam == true;
        }
        if (current.variables.database_onboarded_to_siem_confirmation_approval == 'accept') {
            gr1.u_siem == true;
        }
        if (current.variables.cis_scan_nessus_scan_passed_confirmation_approval == 'accept') {
            gr1.u_nessus == true;
        }
        if (current.variables.ds_am_av_and_network_protect_with_ips_policy_is_set_to_prevent_or_ms_defender_installed == 'accept') {
            gr1.u_av_am_ips == true;
            gr1.u_xdr == true;
        }
        gr1.update();
    }
}

 Replace the name of MRVS variable set in Database section, follow the comment. Also make sure you are using correct variable names in script.

Note : Before saying not working try adding some logs to check and debug script at your end. which loop it is going, what values you are getting etc and share the outcome. We are just assuming variable names and providing logics. Minor corrections should be done by you on your instance.

[Poorva Bhawsar]

I am getting all the logs but the log which is there after updating the record is only returning a sys id. Its a list collector when oat type is server so it should update all. Also its not updating that one record also whose sys id its returning.