1 ACCEPTED SOLUTION
Hi @Rutuja K
From your screenshot above, you can try the below approach.
1. Create an OnChange Client Script in the Product ID [u_product_id] field.
2. Make a GlideAjax call with the same query to the gethostingtype function. Then return an array contains the sys_id of Hosting Type records.
3. Now in Client Script, check if the array length in response and set the value to the Hosting Type.
Sample below.
#Script Include
getServices: function() {
var owner = this.getParameter('sysparm_owner_id');
var arrService = [];
var grService = new GlideRecord('cmdb_ci_service');
grService.addQuery('owned_by', owner);
grService.query();
while (grService.next()) {
arrService.push(grService.getUniqueValue());
}
return JSON.stringify(arrService);
},
#OnChange Client Script
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading) {
return;
}
if (newValue === '') {
g_form.clearValue('business_services');
}
var ga = new GlideAjax('CLCatalogItemUtilAJAX');
ga.addParam('sysparm_name', 'getServices');
ga.addParam('sysparm_owner_id', newValue);
ga.getXMLAnswer(function(answer) {
var service = JSON.parse(answer);
if (service.length === 1) {
g_form.setValue('business_services', service[0]);
return;
}
g_form.clearValue('business_services');
});
}
Enjoy
Cheers,
Tai Vu
