How to return the value in script include and add that in the reference qualifier in the table

[Samiksha2]

Hi All,

I have written the below code. Output is coming correctly. How should I return the sys_id so that it should visible in the reference qualifier field.

getProduct: function() {

        var accounts = current.account;
        var platform = current.u_platform;
        var subProd = current.getDisplayValue("u_sub_products");
 
        var ur = new GlideRecord("u_sub_product");
        ur .addEncodedQuery('u_sub_product=' + subProd + '^u_platform=' + platform);
        ur .query();
        while (ur .next()) {
            var user_array = [];
            var product_array = user_array.push(ur.u_product);
		}
            var dee = new GlideRecord("sn_install_base_sold_product");
            dee.addEncodedQuery("u_platform=" + platform + "^account=" + accounts);
            dee.query();
            while (dee.next()) {
                var prod_array = [];
                var arr = prod_array.push(dee.name);

                if (JSON.stringify(product_array) == JSON.stringify(arr)) {
                    gs.log("OUTPUT RESULTS" + dee.sys_id);
					

                } else {
                    gs.log("FALSE RESULT");
                }
            }
        return dee.sys_id;
       
    },

The return value should populate in the Product field(reference to Sold Product table (sn_install_base_sold_product).

Please help me.

Thanks,
Sam

[Samiksha2]

Hi @Badrinarayan ,
Still single value is returning.
Thanks,
Sam

[Samiksha2]

please see the logs. two values are coming in the output.

[Badrinarayan]

getProduct: function() {

var accounts = current.account;
var platform = current.u_platform;
var subProd = current.getDisplayValue("u_sub_products");

var product_array = [];
var ur = new GlideRecord("u_sub_product");
ur.addEncodedQuery('u_sub_product=' + subProd + '^u_platform=' + platform);
ur.query();
while (ur.next()) {
product_array.push(ur.u_product.toString());
}

var sysIdArray = [];
var dee = new GlideRecord("sn_install_base_sold_product");
dee.addEncodedQuery("u_platform=" + platform + "^account=" + accounts);
dee.query();
while (dee.next()) {
if (product_array.indexOf(dee.name.toString()) !== -1) {
gs.log("OUTPUT RESULTS: " + dee.sys_id);
sysIdArray.push(dee.sys_id.toString());
} else {
gs.log("FALSE RESULT");
}
}

if (sysIdArray.length > 0) {
return 'sys_idIN' + sysIdArray.join(',');
} else {
return 'sys_idINnone'; // No matching records found
}
},

Try this Approach , Let me know if this is Helpful 
share the logs
Thanks

[Sandeep Rajput]

@Samiksha2 Could you please describe in words what exactly your script does. Specially the part which compares 

                if (JSON.stringify(product_array) == JSON.stringify(arr)) {

[Samiksha2]

Hi @Sandeep Rajput ,

I am getting the product value from Sub product table and Product value form Sold product.

Matching the values and if values are equal in sold product table and sub product table the return the equal product value.

Thanks,
Sam