How can I automatically link tickets that has the same field-value?

[Justine]

Whenever there is a new ticket, I want to automatically link it to tickets that has same field-value if that new ticket contains a similar field-value.

[Mark Segall · Accepted solution]

Hi @Justine - You could do something like this:

• TRIGGER: Issue Created
• BRANCH: JQL

  • YourCustomField = {{issue.YourCustomField}} AND key != {{issue}}

  • ACTION: Link Issue to your trigger issue

[Justine]

thanks man!

[Andrew Lee]

Hi,

Any ideas why this would won't work for my automation via Jira Cloud

[Mark Segall]

Hi @Andrew Lee and welcome to the community!

Your branch is staying on the current issue but needs to instead branch into the desired issue(s).  You'll want to change the branch to use JQL.  Ultimately, the rule should look like this:

• TRIGGER: Issue Created
• BRANCH (JQL)

  • cf[xxxxx] = {{issue.customfield_xxxxx}} AND Key != {{issue.key}}

  • ACTION: Link Issue to Trigger Issue

[Matt Munson]

I want to implement this, but I also have about 600 old tickets I'd like to reprocess (and the standard plan so I also have an automation budget). So I am hoping for one automation that is computationally costly, but I only run one time as it will reprocess all the existing issues.

Would something like this work:
TRIGGER: Manual

BRANCH (JQL)

• a query that get all tickets that I want to process
• BRANCH (JQL)
  • cf[xxx] = {{issue.customfield_xxxxx}} AND Key != {{issue.key}}
  • ACTION: Link Issues

-------

I imagine the gotcha comes in specifying the issue.key correctly to mean the issue referred to by the outer branch.

Open to other approaches. Including downloading all tickets to a CSV, reprocessing to do the linkages with a custom R or Python script, and then re-importing all the issues from CSV, but that seems dangerous and drastic... (even it if does allow me to play in my coding comfort zone)