Multiple Conditions in Execute Online SQL type Event Action

​@Abdul Thanks Mr. Abhul. It’s working now.

​@Abdul but that mean that the event is triggered on every status change.

Is there any way to do that differently?

​@dsj  any idea maybe?

Hi,
you can use “Additional Attributes”

define attribute “IS_ENABLED” with SQL

• decode(‘&NEW:ROWSTATE’, ‘Cancelled’, ‘TRUE’, ‘Returned’, ‘TRUE’, ‘FALSE’)
• CASE WHEN ‘&NEW:ROWSTATE’ in (‘Cancelled’,’Returned’) THEN ‘TRUE’ ELSE ‘FALSE’ END

BR
Filip

Hi ​@IFSRUNINNOVAL 

In the event level, it’s only possible to mention the field change as a condition for event trigger, not the field value. Therefore the event will trigger on every status change but the action will only execute based on the condition :)