I am trying to add a Reference Qualifier on a Variable Set that is viewed when ordering a Catalog Item(below) named 'Random Test'. The Variable Set holds the Variable Products which is a reference field. Shown below:
My plan was to create a Script Include that gets an array of Product(s) from the Catalog Item and add that to the reference qualifier field to the Product Field when ordering 'Random Test'.
Here is a snippet of my code from my Script Include(RequestManagerUtils) the function(getRMProducts) is supposed to get a list of the Product(s).
Product(s) field is 'u_product_s'
getRMProducts: function() {
var productList = [];
var gr = new GlideRecord("sc_cat_item");
gr.addQuery("name", gs.getValue("name", gs.getValue("name")));
gr.query();
while (gr.next()) {
productList.push(gr.getValue('u_product_s'));
}
return 'sys_idIN' + productList.join(',');
}Here is the Reference qualifier on the Product variable:
javascript:RequestManagerUtils().getRMProducts();
I feel the biggest part where I am messing up is querying the sc_cat_item table to get the list of Product(s). I am not quite sure how to access the catalog item and the u_product_s field and how to return it in a way for the Product field to understand.
