How to Trigger Business Rule from Related Record Changes?

[thullurishalini]

Hi everyone,

I need to trigger a business rule in a parent record (e.g., Incident) when a field in a related child record (e.g., Work Note) is updated.

[Aditya02 · Accepted solution]

Hi @thullurishalini ,

I accomplished this by creating a business rule on the Work Note (Journal) table (sys_journal_field) that updates a field in the parent Incident when a work note is modified. This in turn triggers a business rule on the parent Incident.

You can follow the below steps and Code for business rule to achieve this:

• Create a Business Rule on the Work Note (Journal) table (sys_journal_field).
• In the Business Rule:
        a. When: After
        b. Condition: You can specify your own condition, such as when a specific field is updated.
        c. Script:

(function executeRule(current, previous /*null when async*/) {
       if (current.element_id == 'incident') {                                 // Check if the work note is related to an incident
             var incidentGR = new GlideRecord('incident');           // Get the parent incident record
             if (incidentGR.get(current.element)) {
                         // Write the script what you want to perform
              }
       }
})(current, previous);

===================================***************=========================================

"If you found my answer helpful, please give it a like and mark it as the accepted solution. It helps others find the solution more easily and supports the community!"

Thanks & Regards,

Aditya

=====================================***********==========================================

[brahmandlapally · Accepted solution]

Hi @thullurishalini.

Create a After BR on table (sys_journal_field) so whenever the worknote updated the BR triggers

Thank you

[Anantha27 · Accepted solution]

Hi @thullurishalini 

You can use the script in the BR at the advance tab as follows

if (current.your_field_name.changes()) {
   var parentRecord = new GlideRecord('incident');
   if (parentRecord.get(current.parent)) {         

parentRecord.state = '3'; 
       parentRecord.update();
   }
}

This may help you to trigger the BR

Thank you

[Sandeep Rajput]

@thullurishalini You’ll need to create a business rule on the child record table that runs when the specific field is updated. This rule will trigger a script that updates the parent record, causing any business rules on the parent to run.

[VishaalRanS]

Hi @thullurishalini 

To trigger a business rule in a parent record (like an Incident) when a field in a related child record (such as a Work Note) is updated in ServiceNow, you can create an After Business Rule on the Child Table and define Conditions:( For instance, you might want it to trigger only when certain fields are updated or when specific conditions are met.)

Please go through the below link:

Solved: Need Business Rule to Update Parent State - ServiceNow Community

Thanks, and Regards

Vishaal

Please mark this response as correct or helpful if it assisted you with your question.

[Ravi Gaurav]

Hi @thullurishalini 
The Below link will help you to build the logic.

https://www.youtube.com/watch?v=A8HHcfix8tI

[OlaN]

Hi,

In the scenario described, it's almost always better to create a Flow instead of writing a custom business rule,

this will most likely skip the need for scripting.