Is it possible to run a JQL Query to identify duplicate issues from a customfield?
For example, Issue A has 'customfield123' (correlation id) which has the value 'INC12345' and I'd like to identify other issues B/C/D that have the same value as 'INC12345' in their 'customfield123'.
The objective is to create a Automation rule that can identify duplicates , link them and then another automation to delete those linked as duplicate.
I'm trying to follow How Delete Issue with the same name (atlassian.com) however this refers to using the summary field, I would like to use a customfield which is our accurate way of identifying the duplicates for our purpose as we have unique issues with the same summary.
What is the branch rule / related issue JQL query we need to use for this objective?
Welcome to the community. Yes, you can use JQL and query against your custom field that have the same value in your custom field.
It will look something like -
project = <projectkey> and customfield = 'INC12345' (NOTE - On your custom field testing, it will depend on the field data type which control on the operator(s) that you can use. Example - if your custom field is a single line of text data type, then you can only use ~, !~, is, is not operators for testing the value)
In regards to Automation Rule setup, you need to first determine what is the triggering event, For a triggering event that uses JQL, you can only use "Scheduled" event, where you can add components of the rule using condition/branching that uses JQL.
Here is a link on Branching rule via Automation for Jira - https://support.atlassian.com/cloud-automation/docs/branch-automation-rules-to-perform-actions-on-related-issues/
Lastly, there is no branching rule via JQL directly.
Hope this helps.
Best, Joseph Chung Yin
Jira/JSM Functional Lead, Global Infrastructure Applications Team