Some users improperly created an absurd number of links between issues of two two projects. This is causing serious JIRA performance impacts.
Removing these links manually is not viable, so I would like to remove these links directly into the database?
Is that possible?
Is there any other way to bulk remove issue links?
The only way I was able to do anything was to go to the primary ticket (the one with all the others linked and delete each link) It was tedious but better than jumping from ticket to ticket to delete the links. I really can not stand that so many logical things need plug-ins/add-ons to do in JIRA. I am not a developer and I feel like you have to be one to get JIRA to do what you need it to do 50% of the time. This should be a bulk change feature!
Contents of Bob Swift's link (however it doesn't appear to be a solution):
Sergio Silva· over 3 years ago
Some users improperly created an absurd number of links between issues of two two projects. This is causing serious JIRA performance impacts. Removing these links manually is not viable.
I saw in the JIRA cli addon documentation that I can delete issue links via comman line, but in the example are required of the issue keys and link type. With JIRA cli I can delete all links of a particular type of all issues found with a JQL search?
Bob Swift [Bob Swift Atlassian Apps] answered on this - over 3 years ago
Yes, I think so. You front end the deleteLink with a runFromIssueList specifying the jql parameter.
Sergio Silva - over 3 years ago
Thanks for your reply.
I am testing this resource and I used the commands below unsuccessfully:
C:\JIRA CLI>jira --action runFromIssueList --jql "issueFunction in hasLinkType('Blocks')" --common " --action deleteLink --link "10000""
Run: --action deleteLink --link 10000
This function requires a non-blank value for parameter: issue
Client error: 1 actions failed
C:\JIRA CLI>jira --action runFromIssueList --jql "issueFunction in hasLinkType('Blocks')" --common " --action deleteLink --issue @issue@ --toIssue @issue@ --link "10000""
Run: --action deleteLink --issue TP-2 --toIssue TP-2 --link 10000
Remote error: JIRA reports: Cannot find link matching these parameters.
Client error: 1 actions failed
I am understanding that I always have to inform the issues that have the link and if I use the reference @issue@ it tries to evaluate a link from one issue to itself.
This appears to be an ongoing issue.
I raised a ticket and was referred to two third party apps including JIRA CLI and Scriptrunner for JIRA.
The only solution is to delete the issue of the link you want to remove - then re-create the issue using the same Key..
If you're wondering whether you can do this - you can. You are able to assign the same key of an item you have deleted, when uploading, the issue is re-created. You will lose the historical information, which may not be a big deal.
Not a bad compromise.
What will happen with the history of the ticket that you are deleting? What if some users have rights to delete issue links , but not to delete the issue ? Unfortunately this is not a good compromise in way to many scenarios. I cannot belive that there is no easy way to delete issue links.
If the work involved in removing the links is far too time consuming, ask the administrator to delete the issue (this will remove the links) then re-upload the issue using the same JIRA key. If you want the history, perhaps you can copy the history and add it as a comment to the new issue.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events