Need to find out issue linked with Story issue type

[Vikrant Yadav]

Hi Guys,

Need your help in JQL query.

I am trying to find out linked issues for a project ABC linked with "Story" issue type only. 

We don't have any external plugin like Scriptrunner or JQL trick which enhacne JQL capability. 

I tried following JQL query using one Linktype , not sure what other link type are used for linking issue with Story . Kindly suggest some work around. 

project = ABC and issueLinkType IN ("Linked from") AND issuetype != Story

[Trudy Claspill]

Hello @Vikrant Yadav 

What do you want to do with the results of the query?

There is not a native JQL option that will satisfy your requirement. The JQL you started above would not get you the issues linked to Stories. It would get you issues that themselves are not Stories, but that also have a linked issue. There is not native option to check that the linked issue is a Story.

How many such issue would you expect to find; less than 100, more than 100, many more than 100?

It might be possible to get a list of such issues through Automation Rules, and you could send yourself the list through email. Getting an emailed list might not satisfy your requirements though.

[Vikrant Yadav]

Hi @Trudy Claspill It's user query to get list of issues linked with Story. Via SR I know we can find out issues irrespective of Link Type. 
Above JQL is not 100% correct, it give some issues based on Link Type. 

May I know how can I do it via automation ? 

[Hannes Obweger - JXL for Jira]

Hi @Vikrant Yadav

if you're open to solutions from the Atlassian Marketplace, this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available, including the linked issue types (along with many other issue-link related columns).

This is how it looks in action:

As you can see above, you can easily sort and filter by your issue's linked issue types. (In the example, I'm filtering for all stories that are linked to at least one bug; you could also easily filter for issues that are linked only to a certain issue type). You can also use your smart columns across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

This all just works - so there's no scripting or automation whatsoever required.

Any questions just let me know,

Best,

Hannes

[Charlotte Santos -Appfire-]

Hi @Vikrant Yadav 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, natively, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to get all issues from project ABC linked to Stories:

issue in linkedIssuesOfQuery("type = Story") AND project = ABC

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

[Amay Purohit_RVS]

Hi @Vikrant Yadav 

If you would be interested in an add-on for this need, you can try out our plugin.

Issue Hierarchy 

The app shows your linked issues in a tree view and the ability to add all your jira columns in the report, plus you will be able to export them as well to a csv file in a hierarchy or a flat format as per your need.

The app has multiple other features which are very useful in project tracking and management.

(Disclaimer: I work on RVS, the vendor for this app)