Look for same Issue Summary

Question

Our JIRA Core instance creates issues via email.  We would like to ensure that emails with the same Summary line (with the same sender) update existing issues rather than create new issues.

For example:

* First email comes into JIRA with the subject line: Testing1, and is from ServiceAccount1, that should create a new issue. 
* Then, if a second email comes in with a subject line of: Testing1, and is also from ServiceAccount1,
* We want the body of the second email to update as a comment to the first issue rather than creating a whole new issue.

Can anyone offer insight here?

Volker Kiehn · Answer

Hi @JD

I was very interested in your example. I had an issue with special characters in summary but I got help from the support.

Using this query will fix it

summary ~ "\" {{ issue.summary }} \""

I'm now using following JQL for the branch and it's working fine

reporter in ({{issue.reporter}}) AND summary ~ "\"{{issue.summary}}\"" AND created != "{{issue.created.jqlDateTime}}" AND status != Ready

(for all germans: status != Fertig )

thanks a lot

Volker

Ellen O_Leary · Answer

Thank you, @JD

I really appreciate you taking the time to experiment for me!

Unfortunately, I am experiencing 2 separate hurdles with this solution:

* I do not seem to have the ability to Create Variable within an automation. 
* The Compare Condition does not allow me to select Summary in the second dropdown.

I am not sure if or how to enable these features within the add-on.  We have version 7.2.2 of the automation add-on to our Jira Core 8.7.0 instance.  Am I missing something that needs to be turned on?

JD_sjez00 · Answer

Ok so this is a bit hacky and I have not tested all cases (but I think it works). I'll explain each component and configurations below the image.

The automation is run whenever a new issue is created. It checks to see if any existing issues have the same issue summary and reporter. If it finds one it will add the new issues description as a comment to the existing issue and then transition the duplicate issue (the new issue) to done.

You will need to do some improvements to the JQL to reduce the impact on your Jira instance, I'll run through it below.

Components

* Issue created: triggers the automation whenever an issue is created.
* Create variable: I named the variable duplicateExists and set its value to null. You create the variable at the start so it can be used in and outside of the branch component.
* Branch: With a relationship type of JQL and then I used some smart values in the JQL search. reporter in ({{issue.reporter}}) AND summary ~ "{{issue.summary}}" AND created != "{{issue.created.jqlDateTime}}"

Automation will replace the information in the curly brackets with the values of the trigger issue (e.g automation will change {{issue.reporter}} to ServiceAccount1).

I'd suggest making your JQL more specific than I have, this will reduce the number of results the automation rule has to process. I would add something around the type of issue that is created and the status of the issue (unless you want it to apply to done issues). Also any other criteria you can think of to reduce the search will help.AND issuetype = <input the type of issue your emails make> AND status in ("To do", "In Progress")

* Issue field condition (inside the branch we created): Check if the summary equals the summary from the trigger issue. This is because JQL does a fuzzy search when matching words so it will include results that have the same words but they might be in a different order. So we'll remove those results now

* Comment on issue (inside the branch we created): This will add a comment to any issue that is found in the above JQL search, so if there are multiple issues with the same reporter and summary then they will all have the comment added.

For the comment I'd suggest {{triggerIssue.description}} this will comment whatever is written in the description of the issue that triggered the automation rule. Also if you want to link to the duplicate issue you could use {{triggerIssue.key}}.

* Create variable (inside the branch we created): Now we want to set the variable we created earlier to "true", this is to show we found a duplicate issue in our JQL search. If no issues are found in our JQL then this will still be "null".

* Advanced compare condition (Outside the brach): This will check the variable we created and if it is true it will run continue the automation.

* Transition issue: this will transition the duplicate issue to done.

Let me know how you get a long. The main issues I ran into was my JQL being slightly wrong. So you might want to do a JQL search in the issue navigator first and then replace parts with smart values.