How do I filter the linked issue type?

Question

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 Answer

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 Answer

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