Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Advanced Notification condition oldvalue from sys_audit

Brian Shacklefo
Tera Contributor

I have configured an HR Service with a custom reference field. I am trying to configure a notification that triggers when the following conditions are met;

  • HR Service is [my HR service]
  • Assigned to is not empty
  • [my custom field] changes
  • [my custom field] is not empty
  • the old value of [my custom field] is not null

The last condition will have to be an Advanced condition as I will need to query the sys_audit table. Below is what I have currently configured, but the notification is still triggering even when the old value of the field is empty. Any ideas out there?

 

Advanced notification condition.png

0 REPLIES 0