nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to avoid duplicate issues being created by an external service

Drew Nedderman

We have Jira Service Desk Cloud. We also have an external service that reports on issues every 15 minutes until the particular issue is solved. For example, we are an ordering platform for restaurants and sometimes a product order will fail to be sent onto their foodservice vendor. We have an alert from the external service that says order number xxxx failed. If the order hasn't gone through by the next time the service checks for it, we get another alert.

The alerts come via a particular email address. The body and subject of the email is the same every time it fires.

I see one ticket per instance of an order number that is failing, so if order number xxxx is failing, I would see one ticket for the first time the service checked, then another ticket for the next time the service checked and so on.

I would like to avoid these duplicates. Since the body and subject of the emails are identical to one another, is this possible through an automation of some sort? I have ScriptRunner and Automation for Jira, but haven't been able to solve this yet.

It doesn't look like advanced mail loop detection is the right fit here since the emails are 15 minutes apart.

Thank you!

- Drew Nedderman

Accepted answers

Simon Wong_5l1oyg

@Drew Nedderman @If Else

You can try using the Lookup Issues action under Automation https://support.atlassian.com/jira-software-cloud/docs/automation-actions/#Automationactions-Lookupissues. You can run a JQL to identify if there are already existing records with the same Summary field as the new issue. If so, cancel (or deleted if you'd like) the new issue automatically.

See the example below.

All comments

PD Sheehan

Speaking about server here... but I think the same is true for cloud.

The default mail handlers have mail threading handling capability.

But that is based on the "message-id" header. If you can somehow cause the external service to generate and re-use a single message-id header for a given alert, then each new email will be appended as a comment on the initial issue created.

Scriptrunner doesn't come between your mail handler and the ticket creation.

The only thing that scriptrunner can do for you is react to the ticket creation, check if a similar ticket exist, then delete or discard the newest one. But any notification associated with the ticket creation or deletion will still take place.

Drew Nedderman

I'll reply back here once I've had a chance to test this. Looks like it could work.

Drew Nedderman

Hi Peter-Dave, we tried sending emails that had duplicate message-id headers, but no luck. Each email created a ticket. Any other thoughts on this? Thank you!

- Drew Nedderman

PD Sheehan

No other ideas. Like I said I haven't worked with Cloud much and I'm not clear on the email handler situation there.

All I'd say is to look carefully at the documentation page:

https://confluence.atlassian.com/adminjiracloud/creating-issues-and-comments-from-email-779288896.html#CreatingIssuesandCommentsfromEmail-messagehandlers

Maybe something could be done using the "in-reply-to" header.

Simon Wong_5l1oyg

@Drew Nedderman @If Else

See the example below.

Lilian_jdjb3z

Thanks for this, it was very helpful. I can confirm it works, but needs a few changes, mainly removing the special characters from the searched summary and escaping quotes (

+ - & | ! ( ) { } [ ] ^ ~ * ? \ :

as documented here: https://confluence.atlassian.com/jiracoreserver073/search-syntax-for-text-fields-861257223.html#Searchsyntaxfortextfields-escapingSpecialcharacters).

summary ~ "{{issue.summary.replace("\"","\\\\\\\"").remove("*").remove("{").remove("}").remove("[").remove("]").remove("+").remove("-").remove("&").remove("|").remove("!").remove("(").remove(")").remove("^").remove("~").remove("?").remove("\\\\").remove(":")}}"

Another change I made to simply delete the newly created ticket instead of transitioning to Canceled.

WAJDI ALZINATI

Hi ,

How can I do the same for a custom field, We need to avoid duplicated issue with same data.

Thanks for help, We have Jira Server

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

scriptrunner

jira

cloud

jira-service-desk

jira-cloud

addon-com.codebarrel.addons.automation