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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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,

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
Community showcase
Published in Jira

Announcing the waitlist for Jira Work Management

Hey there Cloud Community members! We’re excited to give you the first glimpse of the new home for business teams on Jira — Jira Work Management. Jira Work Management is the next generation of J...

1,237 views 18 23
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