Hi @romsar ,

Here’s an event and event action I’ve created which sends the email whenever a shipment status goes from preliminary to completed.  These are working in our test environment.

Regards,

William Klotz

Hello William.

Thanks for your feedback, but in my case, I don’t need to verify the OLD:ROWSTATE value, but just the NEW:ROWSTATE one.

Have you made some tests with the action type = execute online SQL?

Actually, I would need to display a message to the user, so I use the Client_SYS.add_info function.

So that is the exact context that I have to work on.

Edit : I defined my event this way :

On the event action screen, I defined no particular condition to run the event just to verify if my event can well be ran, which is not the case today.

Hi @romsar ,

Unfortunately I do not think you’ll be able to get the Client_SYS.Add_Info working.  In the forums there are many questions and responses to using that API. If you did get it working it would only work using IEE not Aurena.

Information Message (Client_SYS.Add_Info) - This only works in custom events where the event action is triggered against the standard new, modify or remove process … it is the info_ out variable that needs to be handled by the client which makes this possible.

Warning Message (Client_SYS.Add_Warning) - This is currently not supported by the framework.

Regards,

William Klotz

Actually, I manage to get that pop up (but for a weird reason, the displayed message is truncated, I don’t know why, maybe the message is too long), but still, my issue is I don’t manage to run my event only in the case when rowstate goes from Preliminary to Completed, but on the other side, that works (although this context is excluded)

SQL code I used : 

Client_SYS.add_info('Client', 'Rowstate = &NEW:ROWSTATE');