Can someone help me understand why the below is script is not returning any values?
Within the custom form users fill out there is a field called 'submission_type' that is required. Whenever the submission type is 'R.S.G.' I only want to return the 'R.S.G.' products.
Within the Product Table I have 10 values populated with 'R.S.G.', but its not returning any of those products.
var FilterProductList = Class.create();
FilterProductList.prototype = {
initialize: function() {
},
FilterProductList:function() {
var gp = ' ';
var a = current.submission_type;
//return everything if the submission_type value is empty
if(!a)
return;
//ConnectUs Products has the business unit to product relationship
var grp = new GlideRecord('x_hemas_connectus2_connectus_products');
grp.addQuery('business_unit',a);
grp.query();
while(grp.next()) {
if (gp.length > 0) {
//build a comma separated string of products if there is more than one
gp += (',' + grp.product);
}
else {
gp = grp.product;
}
}
// return quired products
return 'sys_idIN' + gp;
},
type: 'FilterProductList'
};
Screen shot from custom form where no products are available to select
Screen Shot from Product Table
