Subquery in filter

[moran.stahi]

Hi,

i'm trying to create subquery in a jira filter, i'm using Jira cloud.

I want to get all the linked issues of some epics.

I want to epics to be a query, for example all the to get all the linked issues for the epics with fixed version = x.

how can i do it?

Thanks,

Moran

[Rahul_RVS]

Hi @moran.stahi 

Welcome to the community !!

If you would be interested in a third party add-on to get all the linked issues for a parent, you can try out our app.

Agile Tools - Epic Tree, Links Tree and Time in Status 

The app helps you to visualize your issue hierarchy and track the progress at each level.

Key features of Links Hierarchy:

• Hierarchy upto 10 levels deep
• Progress % on "remaining estimate" or "original estimates"
• Edit Issue summary, time estimates, story points, assignee and multiple other fields on the tree with real time updates in the progress
• Rolled up percentage completion at all levels
• Ability to add/remove the columns on the report

[Bill Sheboy]

Hi @moran.stahi -- Welcome to the Atlassian Community!

You cannot do that with out-of-the-box JQL, as it is not a SQL.

Your options to solve this dependent upon your frequency of need and cost/effort restrictions:

• need one time
  • export the relevant issues to a spreadsheet and perform the join there
• need often, cost is not a concern
  • investigate the marketplace for apps to enhance JQL features
• need often, cost is restricted, effort is not a concern
  • using the REST API, build an application to pull and join the data in an external reporting tool

Kind regards,
Bill