How to bulk link test cases to user story ?

[Vinayak Mahajan]

I want to link multiple test cases to a user story but unable to do so.

Please help

[Heenaben Sardarbhai Chaudhary]

Hi @Vinayak Mahajan ,

I'm not completely sure if there's an existing feature for this, but you can definitely achieve it with APIs. I actually have a script that performs a similar task, so I thought I'd share it with you.

Quick Summary: This script takes an Excel file with your issue link data and interacts with the Jira API to create those links. It also adds a brief delay between requests to help prevent any issues with API rate limits, which is quite useful.

Here's How It Works:

• Excel File: Ensure your Excel file (e.g., issues.xlsx) is set up with columns like InstanceLink, linkType, parentIssueKey, childIssueKeys, and API_TOKEN. You can use the template provided in the repository for reference.
• Running the Script: Once your Excel file is ready, you just need to run the script using node start.js issues.xlsx. The script will then link each child issue to its respective parent issue as outlined in your file.
• Error Management: If any issues arise, such as missing data or API errors, the script will log a warning but continue processing.

A 100ms delay is built in between API requests to avoid triggering Jira’s rate limiting, so you don’t have to worry about some links failing due to too many requests being sent too quickly.

You can find the repository here.

And while we’re on the subject of automation, if you’re looking to simplify your test case creation and linking process, I’d recommend checking out Test Case Assistant for Jira. This tool helps you automatically generate and attach test cases to user stories with a single click. It even uses AI to generate these test cases based on the specifics of your user stories, making the process both smoother and faster.

Whether you’re managing a few test cases or handling a larger workload, this tool can really streamline your workflow. If you’re interested, feel free to explore the documentation or get it from the marketplace.