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

[Hugues AMEURLAIN]

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,

Regards

Hugues

[Trudy Claspill · Accepted solution]

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.

[Hugues AMEURLAIN]

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 ?

[Trudy Claspill]

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:

https://marketplace.atlassian.com/search?product=jira&query=search%20subtasks

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.

[Hugues AMEURLAIN]

Thanks for your help, have a nice day