1 ACCEPTED SOLUTION
Hello @Ankur Bawiskar ,
Thanks for your response. I have generated the JSON within JavaScript, and as suggested, it provides users with the option to select and update only the required fields. Additionally, I have hardcoded the table name since the Change Request State fields differ and do not align with the INC and RITM fields.
(function execute(inputs, outputs) {
var userinput = inputs.userinput;
var ritmnumber = inputs.ritmnumber;
var state = inputs.state;
var work_notes = inputs.work_notes;
var assigned_to = inputs.assigned_to;
var assignment_group = inputs.assignment_group;
var short_description = inputs.short_description;
var description = inputs.description;
var fields = [
{ field: "work_notes", value: work_notes },
{ field: "assigned_to", value: assigned_to },
{ field: "assignment_group", value: assignment_group },
{ field: "short_description", value: short_description },
{ field: "description", value: description },
{ field: "state", value: state }
];
// Filter out fields where the value is null or an empty string
var fieldsToUpdate = fields.filter(function(item) {
return item.value !== null && item.value !== "";
});
var gr = new GlideRecord('sc_req_item');
// Check if userinput is true
if (userinput == true) {
// Check if the RITM number is found
if (gr.get('number', ritmnumber)) {
// Iterate through the JSON array and update the fields
for (var i = 0; i < fieldsToUpdate.length; i++) {
var field = fieldsToUpdate[i].field;
var value = fieldsToUpdate[i].value;
if (field === "work_notes") {
gr.work_notes = value; // Use the work_notes property directly
} else {
gr.setValue(field, value);
}
}
gr.update();
gs.info('RITM ' + ritmnumber + ' has been updated successfully.');
} else {
gs.info('RITM ' + ritmnumber + ' not found.');
}
} else {
gs.info('User input was false, RITM update skipped.');
}
})(inputs, outputs);
