GlideAjax in Catalog Client Script

[petterbj_rgmo]

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]

Also fixed. Thanks.

We need a Google Docs/live update collaborative feature for things like this.

[petterbj_rgmo]

I implemented the script, but it is still not working. I will add some logs, and add them here!

[Abhinay Erra]

Agree

[petterbj_rgmo]

Script include (Updated):

2. var GSS_GetCategory = Class.create();
3. GSS_GetCategory.prototype = Object.extendsObject(AbstractAjaxProcessor, {
4.   getCategories: function() {
5.   var Categories= [];
6.   //Gliderecord lookup
7.   var gr = new GlideRecord("u_gss_category_mapping");
8.   gr.addQuery('u_internal_service', 'IN' , this.getParameter('sysparm_internal_service_name'));
9.   gr.orderBy('u_internal_service');
10.   gr.query();
12.   while(gr.next()) {
13.   var cObj = {};
14.   cObj.internal_service = gr.getValue('u_internal_service');
15.   cObj.gss_category = gr.getValue('u_gss_category');
16.   Categories.push(cObj);
17.   gs.log("PPP_Script include__1111_   gr.GetValue(u_gss_category) = " + gr.getValue('u_gss_category'));
18.   gs.log("PPP_Script include__2222_   gr.GetValue(u_internal_service) = " + gr.getValue('u_internal_service'));
19.   }
20.   gs.log("PPP_Script include__3333_   This is being returned to the catalog client script = " + Categories);
21.   return JSON.stringify(Categories);
22.   },
23.   _privateFunction: function() { // this function is not client callable
24. }
25. });

Client script (updated):

1. function onChange(control, oldValue, newValue, isLoading, isTemplate) {
2.   if (isLoading || newValue == '') {
3.   //g_form.clearOptions('category');
4.   //g_form.addOption('category', '0', '-- None --');
5.   return;
6.   }
7.   alert("Running Client Script");
9.   //g_form.clearOptions('category');
10.   //g_form.addOption('category', '0', '-- None --');
12.   var ga = new GlideAjax('GSS_GetCategory');
14.   ga.addParam('sysparm_name','getCategories');
15.   ga.addParam('sysparm_internal_service_name',g_form.getValue('internal_service'));
16.   ga.getXML(errorTypeParse);
18.   function errorTypeParse(response) {
19.   answer = response.responseXML.documentElement.getAttribute("answer");
21.   alert("Answer is: " + answer);
23.   var Categories = JSON.decode(answer);
24.   var i = 0;
26.   alert("Categories: " + Categories);
28.   while(i < Categories.length)
29.   {
31.   g_form.addOption('category',Categories[i].internal_service, Categories[i].gss_cateogry);
32.   alert("Inside while loop, print int_s and cat: " + Categories[i].internal_service + " " + Categories[i].gss_category);
33.   i++;
34.   }
35.   }
36. }

Logs:

It is not running the alert which is inside the while loop... So I am guessing it is not going in the while loop for some reason

[Abhinay Erra]

In your client script, add this alert

1. function onChange(control, oldValue, newValue, isLoading, isTemplate) {
2.   if (isLoading || newValue == '') {
3.   //g_form.clearOptions('category');
4.   //g_form.addOption('category', '0', '-- None --');
5.   return;
6.   }
7.   alert("Running Client Script");
9.   //g_form.clearOptions('category');
10.   //g_form.addOption('category', '0', '-- None --');
12.   var ga = new GlideAjax('GSS_GetCategory');
14.   ga.addParam('sysparm_name','getCategories');
15.   ga.addParam('sysparm_internal_service_name',g_form.getValue('internal_service'));
16.   ga.getXML(errorTypeParse);
18.   function errorTypeParse(response) {
19.   answer = response.responseXML.documentElement.getAttribute("answer");
21.   alert("Answer is: " + answer);
23.   var Categories = JSON.decode(answer);
24. alert(Categories.length);
25.   var i = 0;
27.   alert("Categories: " + Categories);
29.   while(i < Categories.length)
30.   {
32.   g_form.addOption('category',Categories[i].internal_service, Categories[i].gss_cateogry);
33.   alert("Inside while loop, print int_s and cat: " + Categories[i].internal_service + " " + Categories[i].gss_category);
34.   i++;
35.   }
36.   }
37. }