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; } } }

Bulk remove/change issue links in Jira

Andrew_ui6xbz

I have some tickets with 100+ issue links associated with them. Is there any way to bulk remove/change links without having to individually delete each link one-by-one? Very time consuming when a large change needs to be made. I have looked all over the forums, but with no success. There are other great bulk change capabilities, but I can't find anything on issue links.

Thanks!

Accepted answers

All comments

Peter DeWitt

@Andrew, have you tried exporting the issues to excel, removing the links and then importing?

.pd

Andrew_ui6xbz

Thank you. I have not tried that. Will that change the issue ID? Trying to find a better way, but perhaps that could work. I guess there is no way to do this within the tool as you can with the other bulk updates?

Peter DeWitt

no - the key will remain the same - try it out on a single issue (preferably in a dev server) to get the feel of it.

Eric Roller

This looks like it could work in theory. However, this is a show stopper: https://jira.atlassian.com/browse/JRACLOUD-63388

Joffrey_Hamman

There is a simple way to link multiple issues to another one:

Open the issue you wish to link to multiple issues.
Select More > Link to display the Link dialog box.
Ensure that the JIRA Issue item is selected at the left of the dialog box.
Below the Issue field, click on the search for an issue link to specify a JQL query which regroups the issues you want to link to the current one.
Click on the link Advanced Search from the Find JIRA issues window.
Enter the specific JQL query and select the issues.
The selected issues should appear in the Issue field.
Click the Link button at the bottom of the dialog.

Note:
If you want to link to 10+ issues, you will need to:
- Run the specific JQL query from the Issue Navigator
- Export the search result from Jira to Excel
- Copy the issue-key column
- Paste in a text editor and replace newline with space or tab
- Paste all the issue keys in the Issue field from the Link dialog box

Hemanth Raju

Hi, i have similar problem;

I have 50+ test cases linked to a user story; later i found those test cases not related to that user story.

Could you please advise, how to un-link those test cases at once instead of removing one after one?

Thanks in advance,

Hemanth

Scott Boisvert

If you have ScriptRunner you can use a script. I'm in the process of upgrading from 7.13 to 8.3 and found that there are some functions that no longer work in 8.3 so I had to write two different scripts. Note, this will delete all links from all issues within the filter, use with caution.

For 7.13:

Credit to Adaptavist for the filter code on this one: https://scriptrunner.adaptavist.com/4.3.6/jira/recipes/misc/running-a-jql-query.html

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.search.SearchProvider
import com.atlassian.jira.jql.parser.JqlQueryParser
import com.atlassian.jira.web.bean.PagerFilter

import org.apache.log4j.Category

def Category log = Category.getInstance("com.onresolve.jira.groovy")
log.setLevel(org.apache.log4j.Level.DEBUG)
log.debug "debug statements"

def jqlQueryParser = ComponentAccessor.getComponent(JqlQueryParser)
def searchProvider = ComponentAccessor.getComponent(SearchProvider)
def issueManager = ComponentAccessor.getIssueManager()
def user = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()

// edit this query to suit
def query = jqlQueryParser.parseQuery("Your JQL Filter")

def results = searchProvider.search(query, user, PagerFilter.getUnlimitedFilter())

log.debug("Total issues: ${results.total}")

results.getIssues().each {documentIssue ->
  //log.debug(documentIssue.key)

  // if you need a mutable issue you can do:
  def issue = issueManager.getIssueObject(documentIssue.id)

  // do something to the issue...
  log.debug(issue.key)
  ComponentAccessor.issueLinkManager.removeIssueLinks(issue, user)
}

For 8.3:

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.IssueManager
import com.atlassian.jira.jql.parser.JqlQueryParser
import com.atlassian.jira.bc.issue.search.SearchService
import com.atlassian.jira.web.bean.PagerFilter
import com.atlassian.query.Query

import org.apache.log4j.Category

def Category log = Category.getInstance("com.onresolve.jira.groovy")
log.setLevel(org.apache.log4j.Level.DEBUG)
log.debug "debug statements"

def searchService = ComponentAccessor.getComponent(SearchService)
def jqlQueryParser = ComponentAccessor.getComponent(JqlQueryParser)
def user = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()
def results = searchService.search(user, jqlQueryParser.parseQuery("Your JQL Filter"), PagerFilter.getUnlimitedFilter())
def issueManager = ComponentAccessor.getIssueManager()

results.getResults().each
{
  def issue = issueManager.getIssueObject(it.id) 
  log.debug(issue.key)
  ComponentAccessor.issueLinkManager.removeIssueLinks(issue, user)
}

Tom Hawkins

https://jira.atlassian.com/issues/?jql=text%20~%20%22bulk%20link%22 has lots in this area, I've just voted for https://jira.atlassian.com/browse/JRASERVER-2428 but "Not Being Considered" doesn't fill me with confidence, however anyone else who doesn't want to go down the "unideal workaround" route, recommend do the same. I realise it may not be simplest thing to achieve, but something in Bulk Edit that works like labels eg. Find and Remove These, Add, Replace all with, then selecting other issues, then bulk linking, would be much better please Atlassian!

Christian Pascher

I would highly recommend to use

ComponentAccessor.issueLinkManager.removeIssueLinksNoChangeItems(issue)

instead of

ComponentAccessor.issueLinkManager.removeIssueLinks(issue, user)

I did tests with Oracle & PostgreSQL and Server & DC and the method removeIssueLinks() floods the db and could make Jira not reacting anymore so you need a restart - or taking 10+ hours to remove thousands of links.

removeIssueLinksNoChangeItems() doesn't creates ChangeItems for the Change History.

Timothy Bassett

No longer relevant with the latest version of JIRA

Sebastian Krzyzanowski_1kh6mn

Hi Timothy - why is this no longer relevant... how can this be achived via the new latest version of JIRA?

Nate Villaume

When I paste the strings into the issue field, the pop-up only allows me to select one at a time.
The KEY is to IGNORE the popup. Click back on the dialog box and your 10+ issues will be parsed.

mochadwi

you can see our approaches to bulk link issues in here: https://community.atlassian.com/t5/Advanced-Roadmaps-questions/Re-Bulk-change-of-issue-link-types/qaq-p/1852501/comment-id/7803#M7803

Teri Michaels_ot66ee

Above only works for first 10 issues found.

Anand_dvau3f

09/03/2022: Cloud Based:

1. When i used the JQL search to get all the jira links, I see in the result only a number which fills the window and not able to load beyond 10

2. Tried the same with Edit, Link and used filter but in this I need to manually select the check box and only 50 show up and rest have to be manually loaded.

Overall experience - BAD

Not sure if there is a easier ways yet

Sergey Shoshin_j3vvg0

Looks like there is no possibility to search by JQL during linking in Jira ticket.

So,

Below the Issue field, click on the search for an issue link to specify a JQL query which regroups the issues you want to link to the current one.
Click on the link Advanced Search from the Find JIRA issues window.

This is not possible.

Welcome!

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

Quick Links

Find more posts tagged with

jira