Question about configuring alarms

[#1]

Hi All,

I would like to configure an alert when the status for records has changed after reload. This seems to work well for numeric conditions but I can not make it work for a text field. I was playing with a condition where I count the 'Closed' status but this dose not work as well.

This is the configuration of the alert:

The 'Trigger Level' has been set to State Changes. I assume that the problem is related to the fact that there can be multiple occasions of a status change between reloads. How to resolve this?

Thanks for your help.

[#2]

Hi, anyone an idea? Thanks for your help.

[rwunderlich · Accepted solution]

The condition will only work if Ticket_List.Status only contains one value. Does it have only a single value?

If the field can have multiple values and you want to fire when one of the values is "Closed", try:

sum(if(Ticket_List.Status ='Closed',1))>0

-Rob

[#4]

Thanks Rob, it works.

[#5]

Hi Rob,

Is it possbile to send an image on an email by using info(photofieldname) via Alerts function?