Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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,


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
Community showcase
Published in Apps & Integrations

Send an Email or Publish to Confluence - What should you do with your release notes?

Background When you hear the words ‘Release notes’, almost always you think of an unsolicited email from a software vendor. But I am here to tell you that from our data, sending release notes via E...

63 views 0 1
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you