Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Subquery in filter

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

2 answers

0 votes
Rahul_RVS_Support Marketplace Partner Dec 29, 2021

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

Links Hierarchy.png

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

875 views 25 28
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you