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

[Ravi Gaurav]

Hi @thullurishalini 

Create a Business Rule on the Work Note (Journal) table (sys_journal_field). Follow these steps:

1. When: Set the condition to "After" the record is saved.
2. Condition: Define your specific condition, such as triggering when a particular field is updated.
3. Script:
   (function executeRule(current, previous /*null when async*/) {
   // Check if the work note is associated with an incident
   if (current.element_id == 'incident') {
   var incidentGR = new GlideRecord('incident'); // Query the parent incident record
   if (incidentGR.get(current.element)) {
   // Add the logic you want to execute here
   }
   }
   })(current, previous);