Need to find out issue linked with Story issue type

Question

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

Amay Purohit_RVS · Answer

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)

Hannes Obweger - JXL for Jira · Answer

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- · Answer

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!