Not able to set values to list collector from script include

[Tanwir Singh11]

Hi All,

I am filtering out the values from list collector (list_of_devices) which is referencing alm_asset table and another reference is location. So, i want to show only those assets which are from that location.

I have created a client script and a script include. I am able to return the sys_id from script include to client script but not able to set them in list collector. Below is my code:

Script include:

 getSiteAssets: function() {
		var arr_name = [];
                var OtoO = this.getParameter('sysparm_type');

                var ast = new GlideRecord('alm_asset');
                ast.addQuery('location', OtoO);
                ast.query();
                while (ast.next()) {                    
					arr_name.push(ast.getUniqueValue());
				}                
                return arr_name.toString();
            },

Client script:

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

    var ga = new GlideAjax('SiteDependentAssets');
    ga.addParam('sysparm_name', 'getSiteAssets');
    ga.addParam('sysparm_type', newValue);
    ga.getXML(parseData);

    function parseData(response) {
        var answer = response.responseXML.documentElement.getAttribute('answer');
		alert(answer);
        g_form.setValue('list_of_devices', answer);
    }
}

Please help.

[AshishKM]

Hi, you dont need to iterate (via for loop ) GlideAjax response in this case. 

use the below 2 line and test.

var result= response.responseXML.documentElement.getAttribute('answer');

alert("Result->"+result); // check the alert values
g_form.setValue('list_of_devices', result);

[Tanwir Singh11]

Hey, i tried using this but it's setting the values,

[AshishKM]

Is this working ? Setting the values are expected based on which column is marked as Display Value= true on that table.

Alert must be showing all sys_id of those records.

[Tanwir Singh11]

It's not working.

Yes, i am getting the sys_id in the alert but its not setting up in the list collector and Display value = true for display_name, so i am returning display name from script include and still not setting the values.

[AshishKM]

return the display name will not work for List Collector because List Collector need sys_id of record from that table only. 

try with this .. use getUniqueValue() for sys_id and return the arr object. 

getSiteAssets: function() {
var arr = [];
var OtoO = this.getParameter('sysparm_type');

var ast = new GlideRecord('alm_asset');
ast.addQuery('location', OtoO);
ast.query();
while (ast.next()) {
arr.push(ast.getUniqueValue());
}
return arr.join()
}, 

Thanks,

Ashish

Please mark correct answer and helpful for others if it works for you