Bulk delete parent link

Question

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

Mor Zahavi_re0grq · Answer

To bulk remove parent link from multiple issues:
Click on the parent so that all it's child issues are shown together, click on the 3 dots -> bulk edit, select all, then select edit issues, go to the "change parent" drop down and select it, then next and confirm.

This will remove the parent link from all issues in this parent.

Tom Lister_fo1j4e · Answer

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

Tom Lister_fo1j4e · Answer

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?