Hi @Younes Choukri
> Have a 'requested for' variable in your catalog item
> Write an On Change client script on that field and a script include as below.
Client script
function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue === '') {
return;
}
g_form.hideFieldMsg('requested_for', true); //give your variable name
if(oldValue != newValue){
var ga = new GlideAjax('Script_Include_Name'); //give your client callable script include name
ga.addParam('sysparm_name', 'checkDuplicate');
ga.addParam('sysparm_user', newValue);
ga.addParam('sysparm_item', g_form.getUniqueValue());
ga.getXML(callback);
function callback(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");
if (answer.toString() == 'yes') {
g_form.clearValue('requested_for', true); //give your field name
g_form.showFieldMsg('requested_for', 'User already submitted a request for this catalog item', 'Error');
}
}
}
}
Script Include :
checkDuplicate: function() {
var user = this.getParameter('sysparm_user');
var item = this.getParameter('sysparm_item');
var gr = new GlideRecord('sc_req_item');
gr.addQuery('cat_item', item);
gr.addQuery('requested_for', user);
gr.query();
if(gr.next())
{
return "yes";
}
else
{
return "no";
},
Mark as correct and helpful if it solved your query.
Regards,
Sumanth
