Triggering automation based on Comment added

Question

I would like trigger an email whenever a comment is added to to a Service Desk request. I'm able to trigger the email successfully however every subsequent comment triggers the same email.

I want the email to be sent only once. Here is the JQL statement and the trigger based on

Trigger:

When: Issue commented

Rule is run when a comment is added to an issue.JQL:labels = ICN_Test AND comment ~ 'Notify Corp Sec' AND (status in ("open","In Progress","Approved"))

Rich Imbrogno · Answer

Thanks for this idea Alex. I will definitely try it. I'm just curious on the need to apply to all issue types since this condition will apply to one specific request type AND issue type only that is not shared with other request types I'm using (not intentional, it just worked out that way :)  )

The reason I mention this is because I am project administrator (not system) and I don't think I have permission to set this for all issue types and don't really want to through that exercise if I don't need to

I think I should be able to target this all through JQL and not impact anything else since any other queries will not be impacted by the value in this field.

Will keep you posted and thank you again.

Alex Koxaras -Relational- · Answer

Hi @Rich Imbrogno

I would suggest that you use a CF as a dummy flag:

* Create a numeric field (or a text) and place it on all issue types (not request types) perhaps on the view screen
* This field is currently empty
* On your rule and your JQL include this field e.g. mynumericfield = null
* When you run the rule and you send the email, edit the issue as well and populate the above field
* Next time the rule will run it will bypass the issue which this field is populated

Let me know if that works for you!