JQL filter for Jira issues and its blocked issues

Question

Hello,

I have succeeded in showing Issues that blocks Issues in the JQL filter and am trying to add a column for the list of its blocked issues but the closes i could get is the "Links" column. Unfortunately, this column shows all of its linked issues (blocking, is blocked by, etc.)

For example:

I have 4 Stories

HR-2: Story - Cat
HR-3: Story - Dog
HR-4: Story - Bird
HR-5: Story - Mouse

Story - Bird and Story - Mouse is blocking Story Dog (HR-3)
Story - Cat is blocking Story Mouse (HR-5)

You may have noticed in the picture that in the Links column, it also included HR-2: Story Cat which is not a blocked issue but rather a blocking issue. I do understand that it is the defined behaviour of the Links column but is there a way to show a blocking issue and only its blocked issue in the JQL filter view or a Jira Dashboard?

Thank you!

Marc -Devoteam- · Answer

Hi @Eamyr Frost

No this can't be done without a marketplace app, as you are no able to filter out values from the field "Links"

The link field provides the linked issues related to the found issues via JQL statements.

If any of the linked issues match the field will still show all linked issues.

Hannes Obweger - JXL for Jira · Answer

Hi @Eamyr Frost,

welcome to the community!

I don't think that this is natively possible in Jira; all I could think of is to use Jira Automation to write the relevant issue links into a separate text field, and then view this separate text field.

This being said, if you're open to solutions from the Atlassian Marketplace, you'll find options there. E.g., your use case would be easy to solve 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. In many cases, you can configure how exactly these fields should be displayed - and for issue links, you can chose the exact issue link types you want to see. This is how it looks in action:

As you can see above, you can easily sort and filter by the blocked issues, and also use them across JXL's advanced features, such as 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

Eamyr Frost · Answer

Thanks Marc! I did change the Outward description of "blocks" to "blocking" and used it in the JQL above.

What i asked is if it is possible to show a blocking issue and only its blocked issue in the JQL filter view or a Jira Dashboard.

Thanks!