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

[OlaN]

Hi,

Your question is a bit unclear, so I guessing a bit on what you want here.

I assume you want to use this function to return some valid sysIDs to use as a reference qualifier on a reference field somewhere.

Then you should return the results as an encoded query string.

If you expect it to be one or more sysIDs, then the return string should look something like this:

return "sys_idIN" + your_variable_containing_sys_id_comma_separated;

Otherwise, please explain in further detail what you want to use this function for.

Another detail, the function references the "current" object multiple times in the code, but the "current" object is not defined, maybe it should be passed as a parameter to the function?

[Samiksha2]

Hi @OlaN ,
Shall I return like this:

Thanks,
Sam

[OlaN]

No, not quite right.

More something like this.

var arrResults = [];
var dee = new GlideRecord("sn_install_base_sold_product");
dee.addEncodedQuery("u_platform=" + platform + "^account=" + accounts);
dee.query();
while (dee.next()) {
	arrResults.push(dee.getUniqueValue());  // store the sysIDs in the array
}

// return the encoded query back to use as a reference qualifier
return 'sys_idIN' + arrResults.join(',');

[Samiksha2]

Hi @OlaN ,
Still only one value is populating in the reference field.
Thanks,
Sam