To resolve this next issue instead of directly pushing each returned GlideRecord object into the array, a new object should be created and then pushed into the array. Then after that stringify the return and then encode/parse the callback response.
For example in the script include:
getData: function() {
gs.log(">-----------FCDevInstDBcontext-------------<");
var records = [];
var incidentsTbl = new GlideRecord('incident');
incidentsTbl.query();
while(incidentsTbl.next()) {
var obj = {};
obj.number = incidentsTbl.getValue('number');
obj.description = incidentsTbl.getDisplayValue('description');
records.push(obj);
}
gs.log(records);
return JSON.stringify(records);
}
Okay, that could be a pain to have to write out all the fields if you need all the fields returned. This could be an alternative:
getData: function() {
gs.log(">-----------FCDevInstDBcontext-------------<");
var records = [];
var incidentsTbl = new GlideRecord('incident');
incidentsTbl.query();
while(incidentsTbl.next()) {
var fields = Object.keys(incidentsTbl);
var obj = {};
fields.forEach(function assignValuesToObj(key){
obj[key] = incidentsTbl.getValue(key);
if(incidentsTbl[key].getDisplayValue())
obj[key + '_dv'] = incidentsTbl[key].getDisplayValue();
});
records.push(obj);
}
return JSON.stringify(records);
}
Then in the glideAjax in the client script:
$scope.getIncidents = function() {
var ga = new GlideAjax("FCDevInstDBcontext");
ga.addParam('sysparam_name', 'getData');
//console.log(ga);
ga.getXMLAnswer(function(answer) {
console.log("Awnser: " + JSON.parse(answer));
alert(answer); //not parsing the alert because it needs to be string here to display correctly in an alert
});
};
