Event Action

You’ll have to add it to the code e.g.

BEGIN

IF ‘&NEW:RESCHEDULE_DATE’ != ‘&NEW:PROMISED_DATE’ THEN 

do something

END IF;

END;

Thank you for the reply. 

I have an Event that captures what I need on the email Notification -  when a date changes execute Action 1

Action 1 was to send an email stating a date was changed. I now need to add a condition before the email is sent, which is the IF statement you sent above. 

Do I now create another Action?  Action 2 - which has the Execute Online SQL - 

The “do something” is send the Email in Action 1.   Thanks for your help. 

You could do something like this in an Execute Online SQL event action. 

BEGIN
IF '&NEW:RESCHEDULE_DATE' != '&NEW:PROMISED_DATE' THEN 
THEN command_sys.Mail(
 from_user_name_ => 'ifsapp',
 to_user_name_ => 'someone@example.com', 
 subject_ => 'Date has changed for Purchase order: &NEW:PURCHASE_ORDER_ID', 
 text_ => 'Purchase order: &NEW:PURCHASE_ORDER_ID has changed. New reschedule date is &NEW:RESCHEDULE_DATE. Promised date is: &NEW:PROMISED_DATE' 
); 
 END IF;
END;