Previous field value not available in Notification on CMDB table (cmdb_ci_business_app)

[SunilkumarP1632]

Hi Team,

I am working on a notification requirement for Business Applications (cmdb_ci_business_app) where an email should be sent when the Operational Status changes, including both FROM and TO values.

Configuration details:

Table: cmdb_ci_business_app

Notification trigger:

Send when: Record Updated

Inserted: Unchecked

Condition: Operational status changes

Email content:

Previous Status: ${previous.operational_status}
Current Status: ${operational_status}

Observed behavior:

Notification triggers correctly on update

Current status value is populated

Previous status value is blank, even though the field value is clearly changing

preview 

Expected behavior (example)

If a Business Application has:

Operational Status = Operational

And it is updated to:

Operational Status = Non-Operational

Then the notification email should contain:

Previous Status: Operational
Current Status: Non-Operational

please help me here how to fix this 

[Ankur Bawiskar · Accepted solution]

@SunilkumarP1632 

you can't use Previous object in notification body directly

Other way

-> after update BR on cmdb_ci_business_app, Condition: Operational status changes

Script:

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

    var oldStatus = previous.operational_status.getDisplayValue();
    var newStatus = current.operational_status.getDisplayValue();
  
    var param1 = "Previous Status: " + oldStatus + "<br/>" + "Current Status: " + newStatus;

    // Trigger the event, passing the data
    gs.eventQueue('your_event_name', current, param1, current.assigned_to); // Create 'your_event_name' in System Policy > Events

})(current, previous);

-> create event on that table and use that in BR script

-> also create notification on your table and make it trigger on your Event

-> Event parm2 contains recipient - True and this is the recipient to whom email will be sent

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@SunilkumarP1632 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[SunilkumarP1632]

@Ankur Bawiskar 

working but - bugs are there where i need to fix this @Ankur Bawiskar 

[SunilkumarP1632]

@Ankur Bawiskar 

As you suggested - 

i have created an event 

Business rule 

modifiyed the notiication 

event 

Result :- 

could you please help me here - what was the mistake happend . 

[Ankur Bawiskar]

@SunilkumarP1632 

why sysId is coming?

is the field name correct operational_status on that table?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏