Trying to populate multiple values in two different fields of catalog item using for loop

[Community Alums]

Hi All,

There are three fields on the form, based on one field I am trying to populate data in two other fields

On Process table we have two reference fields ABC Process Owner and XYZ Process Owner 

1) "Impacted Process" (Field 1 - List collector - can select two or more values) - Multiple options present in the list collector

2) Based on selection in Impacted Process "ABC Process owner"(Field 2 - Multiline text - read only) data should populate line by line (If one Impacted Process is selected then that Process' owner should be populated. If two selections, respectively owner should get populated here line by line)

3) Based on selection in Impacted Process "XYZ Process Owner"(Field 2 - Multiline text - read only) data should populate line by line (If one Impacted Process is selected then that Process' owner should be populated. If two selections, owner should get populated here line by line)

PFB form design

Script Include - 

populateImpactServices: function() {

        var sysid = this.getParameter('sysparm_user_name');
        var obj = {};

        var rec = new GlideRecord('cmdb_ci_business_process');
        rec.addQuery('name', sysid);
        rec.query();
        while (rec.next()) {
            obj.owned_by = rec.getDisplayValue('owned_by').toString();
            obj.managed_by = rec.getDisplayValue('managed_by').toString();
        }
        var data = JSON.stringify(obj);

        return data;

Client Script - 

var arr = {};
    var caller = g_form.getDisplayValue('impacted_process');

  var glide = new GlideAjax('populateImpactServices');
  glide.addParam('sysparm_name', 'populateImpactServices');
  glide.addParam('sysparm_user_name', caller);
  glide.getXMLAnswer(Hello);
  

    function Hello(response) {
        arr = JSON.parse(response);
        var owner = '';
        var manage = '';
        for (var i = 0; i < arr.length; i++) {
            var value = 'Process' + (i + 1) + ': ';
            var value1 ='Process' + (i + 1) + ': ';
            value += arr[i].owned_by;
            value1 += arr[i].managed_by;
            owner += value + '\n';
            manage += value1 + '\n';
        }
        g_form.setValue('abc_process_owner', owner);
        g_form.setValue('xyz_process_owner',manage);

    }

}

Please let me know where I am lagging.

[Community Alums]

Hi Sagar,

I tried what you suggested, I was getting any output. So, I modified some values, now in logs I am getting output but not on the form. when it is looping through records, it is giving same values of previous

PFB script I tried

Script Include - 

populateImpactServices: function() {

        var impacted_process = this.getParameter('sysparm_impacted_process');
        gs.info("impacted_processIds: " + impacted_process); 
        var impacted_processIds = impacted_process.split(",");

        var obj = {};
        var finalArray = [];

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

            var rec = new GlideRecord('cmdb_ci_business_process');
            rec.addQuery('name', impacted_processIds[i]);
            rec.query();
            if (rec.next()) {
                obj.owned_by = rec.getDisplayValue('owned_by').toString();
                obj.managed_by = rec.getDisplayValue('managed_by').toString();
            }
            //finalArray.push(obj);

        }
        // gs.info("finalArray: " + finalArray);
        var data = JSON.stringify(obj);
        gs.log("Line 27"+data);
        return data;
    },

Client Script - 

var arr = {};
    var impacted_processes = g_form.getDisplayValue('impacted_process'); // it can be single or multiple

    alert("impacted_processes: " + impacted_processes);

    var glide = new GlideAjax('populateImpactServices');
    glide.addParam('sysparm_name', 'populateImpactServices');
    glide.addParam('sysparm_impacted_process', impacted_processes);
    glide.getXMLAnswer(Hello);

    function Hello(response) {
        arr = JSON.parse(response);
        var owner = '';
        var manage = '';
        for (var i = 0; i < arr.length; i++) {
            var value = 'Process' + (i + 1) + ': ';
            var value1 = 'Process' + (i + 1) + ': ';
            value += arr[i].owned_by;
            value1 += arr[i].managed_by;
            owner += value + '\n';
            manage += value1 + '\n';
        }
        alert(+arr);
        g_form.setValue('abc_process_owner', owner);
        g_form.setValue('xyz_process_owner', manage);

    }
}

[Community Alums]

Hi Sagar,

with following script include and client script

Script Include - 

populateImpactServices: function() {

        var name = this.getParameter('sysparm_user_name');
        var obj = {};
        var arrayOfObj = [];
        var impacted_processIds = name.split(",");
        var count = impacted_processIds.length;
        gs.log("Line 11:"   +count);

        for (var i = 0; i < count; i++) {
            var rec = new GlideRecord('cmdb_ci_business_process');
            rec.addQuery('sys_id', impacted_processIds[i]);
            rec.query();
            while (rec.next()) {
                obj.owned_by = rec.owned_by.getDisplayValue();
                obj.managed_by = rec.managed_by.getDisplayValue();
            }
            arrayOfObj.push(obj);
        }
        var data = JSON.stringify(arrayOfObj);
            return data;
    },

Client Script - (onChange of Impacted Process field) 

 var caller = g_form.getValue('impacted_process');
    var arr = {};
    
    var glide = new GlideAjax('populateImpactServices');
    glide.addParam('sysparm_name', 'populateImpactServices');
    glide.addParam('sysparm_user_name', caller);
    glide.getXMLAnswer(Hello);

    function Hello(response) {
        arr = JSON.parse(response);

        var owner = [];
        var manage = [];
        for (var i = 0; i < arr.length; i++) {
            owner += arr[i].owned_by + '\n';
            manage += arr[i].managed_by + '\n';
        }
        g_form.setValue('abc_process_owner', owner);
        g_form.setValue('xyz_process_owner', manage);
    }

}

Output - It is repeating values of first input

[Vasantharajan N]

Try this Script Include code block

populateImpactServices : function() {
    var sysid = this.getParameter('sysparm_user_name');
    var obj = {};
    var owned_by_arr = [];
    var managed_by_arr = [];

    var rec = new GlideRecord('cmdb_ci_business_process');
    rec.addQuery('name', "IN", sysid);
    rec.query();
    while (rec.next()) {
        owned_by_arr.push(rec.getDisplayValue('owned_by').toString());
        managed_by_arr.push(rec.getDisplayValue('managed_by').toString());
    }

    obj.owned_by = owned_by_arr.join("\n");
    obj.managed_by = managed_by_arr.join("\n");

    return JSON.stringify(obj);
}

Client script code block

var caller = g_form.getDisplayValue('impacted_process');

var glide = new GlideAjax('populateImpactServices');
glide.addParam('sysparm_name', 'populateImpactServices');
glide.addParam('sysparm_user_name', caller);
glide.getXMLAnswer(Hello);


function Hello(response) {
    var responseJ = JSON.parse(response);
    var ownedBy = responseJ.owned_by;
    var managedBy = responseJ.anaged_by;
    g_form.setValue('abc_process_owner', ownedBy);
    g_form.setValue('xyz_process_owner', managedBy);
}

[Community Alums]

Hi Vasantharajan,

How it would iterate through different different inputs coming from Client script.

Thanks,

Tejas

[Vasantharajan N]

Please use the code in onChange catalog client script so that script will automatically iterate for the values changed and set the value of the respective fields.

I've use "IN' condition in the script include which takes care of it

var rec = new GlideRecord('cmdb_ci_business_process');
    rec.addQuery('name', "IN", sysid);
    rec.query();