I guess you will need a catalog client script and a script include.
Try it with something like this (you may need to tweak it):
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue === '') {
return;
}
// Clear the child_ci choice field first
g_form.clearOptions('child_ci');
// Call the server to get the related child CIs
var ga = new GlideAjax('GetChildCIsAjax');
ga.addParam('sysparm_name', 'getChildCIs');
ga.addParam('sysparm_parentCI', newValue);
ga.getXMLAnswer(function(response) {
var childCIs = JSON.parse(response);
childCIs.forEach(function(ci) {
g_form.addOption('child_ci', ci.sys_id, ci.display_value);
});
});
}
var GetChildCIsAjax = Class.create();
GetChildCIsAjax.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getChildCIs: function() {
var parentSysId = this.getParameter('sysparm_parentCI');
var childCIs = [];
// Query the cmdb_rel_ci table to find related child CIs
var relGR = new GlideRecord('cmdb_rel_ci');
relGR.addQuery('parent', parentSysId);
relGR.query();
while (relGR.next()) {
var childCI = {};
var ciGR = new GlideRecord('cmdb_ci');
if (ciGR.get(relGR.child)) {
childCI.sys_id = ciGR.sys_id.toString();
childCI.display_value = ciGR.getDisplayValue();
childCIs.push(childCI);
}
}
return JSON.stringify(childCIs);
}
});
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
