JQL does not show all linked issues

[Yasmin Aylin]

Hi all,

I am looking for JQL to show all the issues (Tasks, Task, "Test Execution", "Test Set") that are linked to a specific Story.

For some reason, the result was not showing all the issues.

Does someone know the reason?

You can see my JQL with 14 issues results:

Here you can see all the actual linked issues (18 issues):

[Rudy Holtkamp]

Hi @Yasmin Aylin ,

The only thing I can think of is that your 'fixVersion' clause is causing this. In other words not all of your 18 issues have the fixVersion you are looking for.

[Yasmin Aylin]

Hi @Rudy Holtkamp thanks, you're right!!

So maybe you know how can I see all the linked issues that their parent have this fixVersion?

[Hannes Obweger - JXL for Jira]

Hi @Yasmin Aylin

So maybe you know how can I see all the linked issues that their parent have this fixVersion?

Unfortunately, this is trickier than one might think; as a "hierarchical query", it would really require some kind of join or subquery, which isn't available in plain Jira/JQL.

A few directions forward:

• You might be able to use Jira Automation to "propagate" parent information down to the linked issues, and then use the respective field(s) on the linked issues to include them into your filter. Obviously, this will add a fair bit of complexity to your system, and I personally wouldn't recommend it.
• There's different apps from the Atlassian Marketplace that can help with that. First, there's a number of apps that extend JQL by additional functions, including hierarchy- and issue-linking-related functions. I've used JQL Search Extensions a few times and it works well.
• Alternatively, you could try one of the more hierarchy-focused apps from the Marketplace. These apps typically have their own ways of figuring out parent/child relationships between issues, and provide more powerful ways of searching through issue hierarchies. I myself work on such an app, in which your use case would be easy to solve - I'll provide more details below.

Hope this helps,

Best,

Hannes

[Hannes Obweger - JXL for Jira]

Just to expand on the last point, this is how this would look in the app that my team and I are working on, JXL for Jira. Put simply, you'd create a sheet with all issues that are potentially relevant to you, model your issue-link based issue hierarchy (that's just a couple of clicks), and then use JXL filtering capabilities to narrow down to the issues that you care about:

Once you have your list of issues, you can work on these directly in JXL (much like you'd do in e.g. Excel or Google Sheets), trigger various operations in Jira, or export them for further processing.

Any questions just let me know!