How to prevent having duplicate record in asset table

sonita · ‎10-16-2018

on the asset table, we want to prevent having duplicate entries for 'Asset tag'. How to achieve this?

Prateek kumar · ‎10-16-2018

In that case create a before BR on Insert Checked.

(function executeRule(current, previous /*null when async*/) {
var record = new GlideRecord('alm_asset');
record.addQuery('asset_tag', current.asset_tag);
record.query();
if (record.next()) {
gs.addErrorMessage("Asset tag already exists");
current.setAbortAction(true);
}
})(current, previous);

Please mark my response as correct and helpful if it helped solved your question.
-Thanks

View solution in original post

Mark Stanger · ‎10-16-2018

Configure the dictionary entry for the 'Asset tag' field and check the 'Unique' checkbox.

sonita · ‎10-16-2018

it gives me error. doesn't let me as there are already duplicate records there

Mark Stanger · ‎10-16-2018

You need to clean up the duplicates first and make all of the existing data unique. Once you do that you can check the 'Unique' checkbox and it will prevent future duplicates. You can use a 'before insert' business rule, but if you really need to have the data be unique you should clean it up first.

RudhraKAM · ‎10-16-2018

open a record and right click on the asset tag and config dictionary

you should see a unique check box

if it is not there right click

add the unique and check that and save ,,

it might throw an error if there are already duplicates exist