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

lasse3 · ‎05-22-2017

Thank you for the script.

For anyone reading this please notice the following:

1: Use JSON.parse() instead of JSON.decode().

2: You do not need to use the g_form.getValue() function to get the value of the observed field, as this value is already stored in the variable newValue.

Have a nice day!

/Lasse

Chuck Tomasi · ‎08-05-2016

Hi Petter,

Rather than concatening with commas and pipes, why not use an array of objects then pass that. Much simpler to encode/decode.

For example, in your script include, change to using an array.

var Categories = [];

In the while loop, create an object and push that in to the array. Using variables here for readability.

while (gr.next()) {

var cObj = {};

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

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

Categories.push(cObj);

}

then return the JSON object/array as a string.

return JSON.stringify(Categories);

Now in your client script callback, decode the JSON answer;

var Categories = JSON.decode(answer);

for (var i = 0; i < Categories.length; i++) {

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

}

***Much easier to construct, understand, and debug.

Abhinay Erra · ‎08-05-2016

That is what I am about to do. Just waiting for him to post his code so that I can edit.

Chuck Tomasi · ‎08-05-2016

Good catch. Fixed. Anything else you notice?

Abhinay Erra · ‎08-05-2016

this line var Categories = JSON.decode(Categories); should answer instead of categories