Br to prevent deletion

[nafiz435]

Can anyone share a business rule script example that prevents record deletion under certain conditions

[Saloni Suthar]

Hi @nafiz435 ,

The business rule would not work because the business rule will run the logic when the records are deleted. You have to add conditions to the delete ACL on the table. 

[Yashsvi]

Hi @nafiz435,

You could write a before delete business rule that queries associated tables to see if there is are records referencing current and then do a setAbortAction(true) if so.

please check below link:

https://www.servicenow.com/community/developer-forum/prevent-record-to-be-deleted-if-it-has-associat...

Thank you, please make helpful if you accept the solution. 

[Tony Chatfield1]

Hi, you can abort a BR action with a before Delete BR and setAbortAction(); But I would first carefully review the business drives\use case that require this, as I would not normally consider scripted control of record deletion to be best practice and normally records should be retained to preserve audit integrity.

if(current.operation() == 'delete') {
	current.setAbortAction(true);
}

[Its_Azar · Accepted solution]

Hi there @Yashsvi 

you can use an br like below

(function executeRule(current, previous /*null when async*/) {

    /
    if (current.u_status === 'Closed' && current.u_impact === 'High') {
        gs.addErrorMessage('Cannot delete record because it is closed with high impact.');
        current.setAbortAction(true); 
    }

})(current, previous);