I suppose, there is no provision to change the message. However, we can detect that situation early and show a message. Create a client script for that table, use onSubmit event, make a call to server-side by passing 2 column values and record id. server side script include function checks and returns whether exists already or not. accordingly you will stop submit and show message as duplicate.
Client script:
function onSubmit() {
//Type appropriate comment here, and begin script below
var Col1 = g_form.getValue('u_col1');
var Col2 = g_form.getValue('u_col2');
var ga = new GlideAjax('Test');
ga.addParam('sysparm_name','getReferenceTableRecs');
ga.addParam('sysparm_col1',Col1);
ga.addParam('sysparm_col2',Col2);
ga.addParam('sysparm_id',g_form.getUniqueValue());
ga.getXMLWait();
var answer = ga.getAnswer();
alert(answer);
if(answer == "false")
{
alert("Duplicates exists")
return false;
}
return true;
}
At server-side, create a script include like below.
var Test = Class.create();
Test.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getReferenceTableRecs: function()
{
var Col1 = this.getParameter('sysparm_col1');
var Col2 = this.getParameter('sysparm_col2');
var id = this.getParameter('sysparm_id');
var gr = new GlideRecord('u_referencetable');
gr.addEncodedQuery('u_col1=' + Col1 + '^u_col2=' + Col2);
gr.query();
while(gr.next())
{
gs.addInfoMessage(gr.sys_id);
gs.addInfoMessage(id);
if(gr.sys_id.toString() != id.toString())
{
return false;
}
}
return true;
},
type: 'Test'
});
