How to do Bulk linking of multiple issues from one project to user story of another project in jira

[Santosh Prajapati]

Hi,

I am trying to do linking of multiple issues (more than 500 issues) with 'User Story'. Manual mapping seems a huge activity, hence looking for a way how it can be done through functionality like bulk update or so.

Please advise.

Regards

Santosh Prajapati

[Trudy Claspill · Accepted solution]

Hello @Santosh Prajapati 

You could do this through an Automation Rule.

Construct a JQL that selects the issues that all need to be linked to the same issue. 

You can use an Automation Rule with a Schedule trigger to run the JQL to select the issues. In the rule add an action to link the issues to an issue key your specify.

Make sure you uncheck this box in the below the JQL in the Scheduled trigger.

The Link Issue action will initially show "Trigger Issue" in the input field for the issue to link to. Place your cursor in the field and type in the issue key of the issue to which you want to link the issues from your JQL. Click on where it display Issue 'AAA-###' below the field to actually save the issue key into the field.

If you have more than 1000 issues to change you will have to run the rule multiple times. You may also need to change the JQL between runs so that it will not include the issues you've already updated.

Are the source issues and the issue to which you want to link in the same project? If they are not then you will need to create a Multiple-Project scoped rule. Only users with the global Jira permission for Administer Jira can create such rules.

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Santosh Prajapati

just adding to the Automation-based answer above:

If you're looking for a more interactive experience and are open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also allows bulk editing all your editable issue fields - including an issue's issue links - via copy/paste, like so:

You can update any number of issues in one action, so you should be done with your work in now time!

I should add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

[Mikael Sandberg]

Ahh, that has changed...

[Trudy Claspill]

@Mikael Sandberg 

Actually issue linking specifically cannot be modified through the Bulk Change operation.