GlideAjax in Catalog Client Script

petterbj_rgmo · ‎08-05-2016

Hi all,

We have a custom table that contains a service, category and a subcategory. We also have a variable set that is connected to several items. On the variable set there is a field called internal service. When a change happens on this field a catalog client script is run. The catalog client script is doing a glideajax lookup using a script include that goes towards the custom table, trying to lookup all categories for the internal service the user just selected. I have gotten the script working, I am getting every value I need, but when I am trying to add them to the variable in the variable set, only one variable gets stored. It is looping trough all the categories (I checked from logs), but it is not getting added.

Script include:

Catalog Client Script:

Example:

I am choosing my internal service (Finance), then I am supposed to get several categories, but I am only getting the last one one.

Adding the field as well, just for reference:

Any suggestions?

Chuck Tomasi · ‎08-05-2016

Updated Script include (untested)

var GSS_GetCategory = Class.create();

GSS_GetCategory.prototype = Object.extendsObject(AbstractAjaxProcessor, {

getCategories: function() {

var Categories= [];

//Gliderecord lookup

var gr = new GlideRecord("u_gss_category_mapping");

gr.addQuery('u_internal_service', 'IN' , this.getParameter('sysparm_internal_service_name'));

gr.orderBy('u_internal_service');

gr.query();

while(gr.next()) {

var cObj = {};

cObj.internal_service = gr.getValue('u_internal_service');

cObj.gss_category = gr.getValue('u_gss_category');

Categories.push(cObj);

gs.log("PPP_Script include__1111_ gr.GetValue(u_gss_category) = " + gr.getValue('u_gss_category'));

gs.log("PPP_Script include__2222_ gr.GetValue(u_internal_service) = " + gr.getValue('u_internal_service'));

}

gs.log("PPP_Script include__3333_ This is being returned to the catalog client script = " + Categories);

return JSON.stringify(Categories);

},

_privateFunction: function() { // this function is not client callable

}

});

Updated client script (untested)

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

if (isLoading || newValue == '') {

//g_form.clearOptions('category');

//g_form.addOption('category', '0', '-- None --');

return;

}

alert("Running Client Script");

//g_form.clearOptions('category');

//g_form.addOption('category', '0', '-- None --');

var ga = new GlideAjax('GSS_GetCategory');

ga.addParam('sysparm_name','getCategories');

ga.addParam('sysparm_internal_service_name',g_form.getValue('internal_service'));

ga.getXML(errorTypeParse);

function errorTypeParse(response) {

answer = response.responseXML.documentElement.getAttribute("answer");

alert(answer+"testIDandCategory");

var Categories = JSON.decode(answer);

var i = 0;

while(i < Categories.length)

{

g_form.addOption('category',Categories[i].internal_service, Categories[i].gss_cateogy);

i++;

}

View solution in original post

Abhinay Erra · ‎08-05-2016

What is the type of variable you are trying to add options?

petterbj_rgmo · ‎08-05-2016

It is a variable on a variable set:

Abhinay Erra · ‎08-05-2016

Petter,

I could not see any see any issues in variable type. You should be able to add the options. For testing, open the form, press cntrl+shlft+alt+J to open the javascript executor and put this script in there and run the code and see if it is adding the options

g_form.addOption("category","Test","Test");

g_form.addOption("category","Test1","Test1");

g_form.addOption("category","Test2","Test2");

petterbj_rgmo · ‎08-07-2016

I tested this yesterday and it works just fine adding options by hard coding the options. I added the code, just as suggested by you:

g_form.addOption("category","Test","Test");

g_form.addOption("category","Test1","Test1");

g_form.addOption("category","Test2","Test2");

Every alert prints just fine, as I added alot of logs. I think it is this line of code that is making my life miserable:

g_form.addOption('category',Categories[i].internal_service, Categories[i].gss_cateogry);

petterbj_rgmo · ‎08-08-2016

Okei, so I solved it. The thing is that the value that was taken from the custom table my co-worker made was picking up the same ID for different categories. So all it did was overwrite all the categories. Thank you all for your help, it has been amazing!