Need to find out issue linked with Story issue type

Vikrant Yadav
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 4, 2024

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

4 answers

2 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 5, 2024

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 5, 2024

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 ? 

1 vote
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 22, 2024

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:

linked-issue-types.gif

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

1 vote
Charlotte Santos -Appfire-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 5, 2024

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!

0 votes
Amay Purohit_RVS
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 22, 2024

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)

Links HIerarchy.PNG

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events