How to bulk link test cases to user story ?

[Divya Teja G]

I want to link multiple testcases to the user story., please assist.

[Artem Fomin - DevOps Action]

You can have a list of your test case keys (one per line or tab-separated), then navigate to your Story > Link and paste the list of issue keys there.

[Nicolás Sánchez]

This doesn't work. You have to still manually select the ticket yu want to link from the list of ticket Id's. 
You then have to repeat the process one by one to link all of the tickets in your list

[Richard Bariny]

Did you solve it?

[Sathish]

No

[dnavashola]

Hey, I’m not entirely sure if there's an inbuilt feature for this, but you can definitely get it done using APIs. I actually had a script lying around that does something similar, so I thought I’d share it.

Quick Overview:

This script processes an Excel file with your issue link data and sends requests to the Jira API to create those links. It even adds a little delay between requests to avoid hitting any API rate limits, which can be a lifesaver.

How It Works:

• Excel File: Make sure your Excel file (issues.xlsx) is ready with columns like InstanceLink, linkType, parentIssueKey, childIssueKeys, and API_TOKEN.(You can can take reference from template from repo)
• Running the Script: Once your file is good to go, just run the script with node start.js issues.xlsx. The script will handle the rest, linking each child issue to the parent issue listed in your file.
• Error Handling: If anything goes wrong (like missing data or API errors), the script logs a warning but keeps chugging along.

I added a 100ms delay between API requests to prevent any issues with Jira’s rate limiting. This way, you don’t have to worry about some links failing because too many requests were sent too quickly. 

You can find the repo here 

And while we’re on the topic of automation, if you’re looking to streamline your test case creation and linking, you might want to check out Test Case Assistant for Jira. This tool doesn’t just save you time by automatically creating and attaching test cases to user stories with a click—it also uses AI to generate the test cases based on your user story details. So, instead of manually writing out test cases, the AI does the heavy lifting for you.

Whether you're dealing with a few test cases or managing a large backlog, this can make the whole process a lot smoother and faster. If you’re curious to learn more, you can check out the documentation or grab it from the marketplace