Hello Moedeb,
Sorry to interrupt in between, I would like to add something which might resolve this query,
could you please share the code which you have written if it is?
for the same you can write script include with multiple functions which guide sys_user and alm_asset tables to get the necessary details and associated onChange catalog client scripts.
e.g.
I have write one script include and client scripts to get details something like your requirement
SCRIPT INCLUDE
getData: function()
{
var sysid=this.getParameter("sysparm_id");
var gr = new GlideRecord("sys_user");
gr.addQuery("sys_id", sysid);
gr.query();
var arr1=[];
while (gr.next())
{
return gr.email;
//gs.addInfoMessage("email= "+email);
}
},
getAssetData: function()
{
var sysid=this.getParameter("sysparm_id");
var gr=new GlideRecord('alm_asset');
gr.addQuery('assigned_to',this.getParameter("sysparm_id"));
gs.addInfoMessage("sys_id in asset function "+sysid);
gr.query();
var arr=[];
while(gr.next())
{
arr.push(gr.getValue("display_name")+" ");
}
return arr.toString();
},
type: 'GetDetails'
});
CLIENT SCRIPT:
1:For email
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
var ga=new GlideAjax('GetDetails');
ga.addParam('sysparm_name','getData');
ga.addParam('sysparm_id',newValue);
ga.getXML(callback);
function callback(response)
{
var ans=response.responseXML.documentElement.getAttribute('answer');
g_form.setValue("requested_for_email",ans);
}
}
2:For asset
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
var ga=new GlideAjax('GetDetails');
ga.addParam('sysparm_name','getAssetData');
ga.addParam('sysparm_id',newValue);
ga.getXML(callback);
function callback(response)
{
var ans=response.responseXML.documentElement.getAttribute('answer');
g_form.setValue("assets",ans);
}
}
You need to just add function in script include to get manager details and associated catalog client script to set those values into the variables.
Hope this will help you to resolve your query.
Kindly mark the answer correct and helpful if it will resolved your query.
Regards,
Akshata
(ServiceNow Developer).
