KACE Product Support : Send an email when a new ticket is created and custom field checkbox is not check

Send an email when a new ticket is created and custom field checkbox is not check

Hello,

I want to create a rule that will send an email to a group of persons when a new ticket is created and a custom field (checkbox) is not check.

New ticket --> checkbox custom field check --> no email sent

New ticket --> checkbox custom field not check --> email sent to a mailing list

I've already a "new ticket email" rule in place, but I'm not sure how to modify it to include the condition above.

Can someone guide me on the proper syntax ?

Thanks in advance!

0 Comments [ + ] Show comments

Posted by: dtisoft 8 years ago

Found the solution. I simply added this condition at the end of the sql query:

WHERE

C.DESCRIPTION LIKE 'TICKET CREATED%' AND !HD_TICKET.CUSTOM_FIELD_VALUE1 (custom field1 is the checkbox custom field).

Thx!

Answer this question

question