using business rule, prevents from creating/ updating a new record if a record already existed .

[William Dalogdo]

Hi, Totally newbie here. I would like to ask how to  prevent creation of a new record, if a record already existed in business rule.   

[Ankur Bawiskar · Accepted solution]

Hi,

why not make the u_reference_1 field as Unique at dictionary level?

In this way no business rule is required

In case you still want to use business rule then use this

Before Insert

Script:

var gr = new GlideRecord(current.getTableName());
gr.addQuery("u_reference_1", current.u_reference_1);
gr.query();
if (gr.hasNext()) {   
	gs.addErrorMessage("not allowed");
	current.setAbortAction(true);
}

Regards
Ankur

[William Dalogdo]

thank you man. How Brilliant!

[Ankur Bawiskar]

Glad to know that it helped.

Please mark response helpful as well.

Regards
Ankur