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?

[Abhinay Erra]

Petter,

can you post the code instead of screenshot. That way I could make changes to your code easily.

[petterbj_rgmo]

Script include:

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

Catalog client script:

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.   }
8.   alert("Running Client Script");
10.   //g_form.clearOptions('category');
11.   //g_form.addOption('category', '0', '-- None --');
12.   var ga = new GlideAjax('GSS_GetCategory');
13.   ga.addParam('sysparm_name','getCategories');
14.   ga.addParam('sysparm_internal_service_name',g_form.getValue('internal_service'));
15.   ga.getXML(errorTypeParse);
17.   function errorTypeParse(response) {
19.   answer = response.responseXML.documentElement.getAttribute("answer");
20.   alert(answer+"testIDandCategory");
23.   var splitStr = answer.split(",");
24.    
25.   var tmpStr = splitStr.slice(0,-1);
26.   alert("tmpStr + split = " + tmpStr);
27.   var i = 0;
30.   while(i < splitStr.length)
31.   {
32.   var splitValues = tmpStr[i].split('|');
34.   g_form.addOption('category',splitValues[0],splitValues[1]);
35.   i++;
37.   }
38.   }
39. }

[Chuck Tomasi · Accepted solution]

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++;

  }

  }

}

[Abhinay Erra]

A minor correction, in the client script

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