Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

Query JQL : requesting issues with a criteria linked to their subtasks

I would like to get all the issues whose at least one of the substasks has a target end lower than a specific date.

Could you help me ?

By adbance thanks,



3 answers

1 accepted

0 votes
Answer accepted

Hello @Hugues AMEURLAIN 

Welcome to the community.

Is this a query you will need to execute many times or only once or a few times?

JIRA Cloud by itself does not have anything to support that type of query. Do you have any apps installed that extend the query functionality, or is it an option for you to subscribe to such apps? There are a variety of apps available that extend the query functionality that might be able to help with your task.

Hi Trudy,

Thank you for your answer, 


The query will be needed to be executed many times.


To be honest, I wasn't aware of the possibility to extend queries fonctionnality by getting apps.

How can I choose the good apps ? How much does it cost ?

There are several such apps at varying costs available through the Marketplace. You can search the marketplace using keywords to try to find apps that relate to your need. Here is one such search:

Make sure when you look at the details for an app that you are ensuring it is supported for Cloud. There is a pull-down in the upper right corner of each app page for selecting information for the supported platforms. Most apps provide links to their documentation so you can review that to see if it has more detailed information about what the app can do. I use the reviews and number of installs also to help me determine if I want to take a chance on the app.

Thanks for your help, have a nice day

Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Published in Jira

Building a powerful Kanban dashboard in Jira with Great Gadgets app

Kanban is a popular agile framework suitable for both operations and development teams. It does not matter if you are a support team handling issues reported by customers, an internal service desk te...

9 views 0 0
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