Why Before Update Business rule working while insertion

[Saranya2]

Hi All,

->We have a before update business rule on change request table where we are checking when we don't have incident number added on any of these two related lists "Incident Fixed by Change" or "Incident Caused by Change", it is throwing error.

->But as per the business rule it should trigger only when updating the record, but it is also triggered while insertion.

-> We have checked we haven't used current.update() in any of the before insert/update business rule.

Not sure how it is happening, how to fix this issue? can anyone please suggest?

BR:

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

var cin = new GlideRecord("incident");
        cin.addEncodedQuery("rfc=" + current.sys_id + "^ORcaused_by=" + current.sys_id);
        cin.query();
        if(!cin.hasnext()) {
            gs.addErrorMessage('Emergency changes must have an associated Incident.  Please verify you have an associated Incident listed in either \"Incidents Caused by Change\", \"Incidents Fixed by Change\"');
            current.setAbortAction(true);
        } 
})(current, previous);

Thanks,

Saranya

[VaishnaviShinde]

@Saranya2 

Try the below code

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

var cin = new GlideRecord("incident");
        cin.addEncodedQuery("rfc=" + current.sys_id + "^ORcaused_by=" + current.sys_id);
        cin.query();
        if(!cin.hasnext()) {
            gs.addErrorMessage('Emergency changes must have an associated Incident.  Please verify you have an associated Incident listed in either \"Incidents Caused by Change\", \"Incidents Fixed by Change\"');

            current.setWorkflow(false);
            current.setAbortAction(true);
        } 
})(current, previous);

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

[Saranya2]

Hi @VaishnaviShinde,

I have added current.setWorkflow(false); still it is triggering while insertion.

[VaishnaviShinde]

Hi @Saranya2 

Please add below code:

var cin = new GlideRecord("incident");
cin.addEncodedQuery("rfc=" + current.sys_id + "^ORcaused_by=" + current.sys_id);
cin.query();
gs.info('count of request:'+cin.getRowCount()+' '+current.number);
if (cin.next()) {
gs.info('In if');
}else{
gs.info('In else');
gs.addErrorMessage('Emergency changes must have an associated Incident. Please verify you have an associated Incident listed in either \"Incidents Caused by Change\", \"Incidents Fixed by Change\"');
current.setWorkflow(false);
current.setAbortAction(true);
}

For me it works. Please check let me know if you stuck

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

[Allen Andreas]

Hi,

If you're meaning that the business rule is running on insert and update and it shouldn't do that, then you'd want to uncheck the "Insert" box on this specific business rule configuration.