avoid duplication in location table

[divya123]

in location table whenever adding location filed value manually if that   location is already existed then it show message that already existed that location &   show invalid insert , this is what show if location is already existed in location table(cmn_location).

kindly help me with your suggestion how can i write business rule for that.

Thanks

Divya

[nthumma]

use below script in on before BR on Insert

   var target = new GlideRecord('cmn_location');
       target.addQuery('name', current.name);
       target.query();     // Issue the query to the database to get relevant records
       if (target.next()) {
               // add code here to process the incident record
               gs.addErrorMessage("Location Name already exists.");
               current.setAbortAction(true);
       }

[divya123]

Thank you Srnewbie for your response,   code is working fine

[Alikutty A]

Hi Divya,

You can achieve this oob by updating the unique flag on the name field.

OR

Write an onbefore insert business rule on location table for validation.

var gr = new GlideRecord('cmn_location')

gr.addEncodedQuery('name='+current.name);

gr.query()

if(gr.next()){

gs.addInfoMessage('YOUR MESSAGE HERE');

current.setAbortAction(true);

}

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

[Alikutty A]

Here is how you set the unique field for location name (The field need to be added in the form layout of dictionary)

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response