How do I filter the linked issue type?

[Augusto Romaniuk]

I was making this JQL filter: 

project = "DEV" AND issuetype IN ("Story") AND issueLinkType IS NOT EMPTY


And I need to add a condition that certifies the type of the item linked to the story to be a "BUG", because with my filter, Jira shows me too Tasks..


In this pic, the column "BUG" is the LINKED ISSUE.

[Florian Bonniec · Accepted solution]

Hi @Augusto Romaniuk 

I do not see any way to achieve this without an app such as Scriptrunner and enhanced search.

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/scriptrunner-enhanced-search-jql-functions/links-and-relationships

Regards

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Augusto Romaniuk

as I see that you're using JXL for Jira, another option would be to perform the issue link type filtering directly in JXL, using JXL's column filtering capabilities.

E.g., you could add the Linked issue types smart column, and filter it by Bug, like so:

For context, 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 long list of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

[Augusto Romaniuk]

Bro, you are a life saver.. Thank you!

[Charlotte Santos -Appfire-]

Hi @Augusto Romaniuk 

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 the stories from project DEV, that have bugs linked to them:

issue in linkedIssuesOfQuery("type=Bug") AND type = Story AND project = "DEV"

Please contact our support if you have any other questions about this query, or the app in general.

We’ll be happy to help you! 😉