Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,459,764
Community Members
 
Community Events
176
Community Groups

How to get issues (type=Story) that are linked to other issues (type=Bug)?

Dear all,

I would need to extract all the issues from our projecy (type=Story) that have been tested by business who created issues (type=Bug) linked to the issue they tested.

From that extract I would need to get the following columns:

- Story id, story summary, story status

- linked Bugs id, bugs status

Thanks in advance for your help.

Best regards,

Kha-Luan

1 answer

0 votes

Hello @Kha-Luan PHAM

Welcome to the Atlassian Community!

It is possible to configure a JQL query to return all Stories with a specific link type and export it to a CSV file with the fields you want, however, it is not possible to filter by the issue type of the linked issue (bug).

That being said, if your issues only get linked when have been tested by business and there are no other scenarios that you link them with that specific link-type, you can follow the steps below to achieve your need:

  1. Search for your issues using the following JQL query, updating "Issuelinktype" by the type of link you used (Related to, blocked by, etc):
    issuetype = Story and issueLinkType = "Issuelinktype"
  2. In the same issue navigator page, select to display the query in List view, selecting in the Columns menu what fields you want to display in your export:
    Screen Shot 2020-05-26 at 17.20.53.png
  3. Then, click on Export and select the option "Export Excel CSV (Current fields)":
    Screen Shot 2020-05-26 at 17.25.54.png

Now, if you also link issues using the same link for other scenarios, I would recommend creating a separate link-type to identify the issues that have been tested by business in the JQL.

Let us know if this information helps.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events