question Re: Catalog Client Script Getting Null Value from Working Script Include. in SysAdmin forum

Catalog Client Script Getting Null Value from Working Script Include.

Alan42 — Wed, 31 Jul 2024 20:13:08 GMT

I have a table that contains employee data by plant. When I select 'plant' on a catalog item form I want the QC Manager, Plant Accountant, and Shipping Manager fields to auto populate. My script include tests out correctly and returns the correct data.

Name - PlantManagerFetcher
Client Callable
All Application scopes

var PlantManagerFetcher = Class.create();
PlantManagerFetcher.prototype = {
initialize: function() {},

getManagersByPlant: function(plantName) {
var result = {};
var gr = new GlideRecord('u_rwi_plants');

// Use the correct column names
gr.addQuery('u_plant', plantName);
gr.query();

if (gr.next()) {
result.qc_manager = gr.getValue('u_qc_manager');
result.plant_accountant = gr.getValue('u_plant_accountant');
result.shipping_manager = gr.getValue('u_shipping_manager');
}
return result;
},

type: 'PlantManagerFetcher'
};

I've tried a half dozen variants of the catalog client script but keep getting a null error. Is there anything that stands out in the catalog client script?

Catalog Client Script
Name - Plant
All
OnChange

Variable Name - u_plant

function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue === '') {
return;
}

console.log('Selected Plant:', newValue);

var ga = new GlideAjax('PlantManagerFetcher');
ga.addParam('sysparm_name', 'getManagersByPlant');
ga.addParam('plantName', newValue);
ga.getXMLAnswer(function(response) {
console.log('Response:', response);

try {
var managers = JSON.parse(response);
console.log('Parsed Managers:', managers);

console.log('QC Manager:', g_form.getValue('u_qc_manager'));
console.log('Plant Accountant:', g_form.getValue('u_plant_accountant'));
console.log('Shipping Manager:', g_form.getValue('u_shipping_manager'));

} catch (e) {
console.error('Error parsing JSON response:', e);
}
});
}

Re: Catalog Client Script Getting Null Value from Working Script Include.

Arya123 — Thu, 01 Aug 2024 03:11:53 GMT

Hi @Alan42

Please try and see the below code:

Script Include:

var PlantManagerFetcher = Class.create();

PlantManagerFetcher.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {

getManagersByPlant: function(plantName) {

var result = {};

var gr = new GlideRecord('u_rwi_plants');

// Use the correct column names

gr.addQuery('u_plant', plantName);

gr.query();

if (gr.next()) {

result.qc_manager = gr.getValue('u_qc_manager');

result.plant_accountant = gr.getValue('u_plant_accountant');

result.shipping_manager = gr.getValue('u_shipping_manager');

}

return result;

type: 'PlantManagerFetcher'

});

Client Script:

function onLoad() {

var plantName = g_form.getValue('plant_name_field'); // Replace with the correct field name

if (plantName)

{

getManagersByPlant(plantName);

} }

function getManagersByPlant(plantName)

{

var ga = new GlideAjax('PlantManagerFetcher');

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

ga.addParam('plantName', plantName);

ga.getXMLAnswer(processResponse);

}

function processResponse(response)

{

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

var result = JSON.parse(answer);

if (result)

{ g_form.setValue('qc_manager_field', result.qc_manager); // Replace with the correct field name g_form.setValue('plant_accountant_field', result.plant_accountant); // Replace with the correct field name g_form.setValue('shipping_manager_field', result.shipping_manager); // Replace with the correct field name } else { g_form.addErrorMessage('No managers found for the selected plant.');

} }

Re: Catalog Client Script Getting Null Value from Working Script Include.

Bhavani Shankar — Sat, 03 Aug 2024 02:56:56 GMT

Hi @Alan42,

Like @Arya123 suggests, client callable script include must extend AbstractAjaxProcessor which is missing from your script include. Please try to modify your script to extend AbstractAjaxProcessor.

Regards,

Bhavani Shankar

Re: Catalog Client Script Getting Null Value from Working Script Include.

Alan42 — Tue, 06 Aug 2024 14:30:52 GMT

Thank you. Your suggested changes worked. Here are the edits that finally did the trick.

var PlantManagerFetcher = Class.create();
PlantManagerFetcher.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getManagersByPlant: function() {
var plantName = this.getParameter('sysparm_plantName');
var result = {};

var gr = new GlideRecord('u_rwi_plants');
gr.addQuery('u_plant', plantName);
gr.query();

if (gr.next()) {
result.qc_manager = gr.getValue('u_qc_manager');
result.plant_accountant = gr.getValue('u_plant_accountant');
result.shipping_manager = gr.getValue('u_shipping_manager');
}

return JSON.stringify(result);
},

type: 'PlantManagerFetcher'
});

function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue === '') {
return;
}

console.log('Selected Plant:', newValue);

var ga = new GlideAjax('PlantManagerFetcher');
ga.addParam('sysparm_name', 'getManagersByPlant');
ga.addParam('sysparm_plantName', newValue); // Correct parameter name
ga.getXMLAnswer(function(response) {
console.log('Response:', response);
try {
var managers = JSON.parse(response);
console.log('Parsed Managers:', managers);

// Update form fields with the fetched manager data
g_form.setValue('u_qc_manager', managers.qc_manager || '');
g_form.setValue('u_plant_accountant', managers.plant_accountant || '');
g_form.setValue('u_shipping_manager', managers.shipping_manager || '');
console.log('QC Manager:', g_form.getValue('u_qc_manager'));
console.log('Plant Accountant:', g_form.getValue('u_plant_accountant'));
console.log('Shipping Manager:', g_form.getValue('u_shipping_manager'));
} catch (e) {
console.error('Error parsing JSON response:', e);
}
});
}