Bulk delete parent link

[Marina Barbir]

Hi, 

I am looking for a way to delete more than 1000 tasks from a parent node. I tried both - working on the parent node and working on the children - but no luck.

• Going into the parent node I can only delete one linked child at a time so it's pretty time consuming.
• Going to the search and performing a bulk edit of all children does not let me edit issue links.

Any workaround or tip that could save me a night shift?

Thanks!

Marina

[Tom Lister]

Hi @Marina Barbir

are you able to use any scripting tools in your Jira installation?

are the issues related to parent via issue links or as sub-tasks?

[Tom Lister]

Hi

If you can run SQL, this will enable you to get the id's of issue links

SELECT 
il.id as linkid,
ilt.linkname,
concat(pr.pname,'-',ji1.issuenum) as source_key,
concat(pr.pname,'-',ji2.issuenum) as dest_key
 FROM issuelink il, issuelinktype ilt, jiraissue ji1, jiraissue ji2, project pr
where ilt.id = linktype
and source = ji1.id
and destination = ji2.id
and pr.id = ji1.project

you could then create 'curl' calls to remove those links

curl -insecure -u admin:admin -X DELETE -H "Content-Type: application/json" http://localhost:8080/rest/api/2/issueLink/10101

[Thomas B]

Hello @Marina Barbir,

I believe you are trying to delete all issues that have a link to some parent issue. If so, you could perform a search issue in linkedIssues("ParentIssueID") 

1. Select Tools
2. Bulk Change: all issues.
3. Select all issues to delete and hit Next
4. Select Delete Issues

I hope this is what you were looking for!

Thanks

[Marina Barbir]

Hi @Thomas B, 

I am actually not trying to delete the issues themselves but I want to "unlink" them from the parent, which doesn't seem to be possible via bulk edit?

Thanks for your quick response however.