Obtener el estado del padre

Jose Lago
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 23, 2024


Estoy haciendo una jsql y quiero obtener todas las subtareas que tengan su padre con estado cerrado.


Muchas gracias


3 answers

1 vote
Stephen Wright _Elabor8_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 23, 2024

Hi @Jose Lago 

You can't do this natively in JQL - sub-querying is only available in advanced JQL apps

You could check out Apps such as...

You can then use functions like...

  • subtasksOf(subquery) - finds Sub-tasks of issues specified by the sub-query
  • ParentStatus - finds Sub-tasks based on a parent's Status


An alternative is to populate the Sub-tasks with the parent issue's Status using Automation - so you could use this metadata in standard JQL.

For example...

  • Create a custom field, such as a Select List (with the status options), or a Text Field
  • Use Automation to modify the field each time the parent is transitioned


Let us know your thoughts!




And in Spanish, according to Google Translate (and without the Apps/Links)...

No puede hacer esto de forma nativa en JQL: las subconsultas solo están disponibles en aplicaciones JQL avanzadas. Vea los enlaces a las opciones de la aplicación arriba.

Luego puedes usar funciones como...

  • subtasksOf(subconsulta): busca subtareas de problemas especificados por la subconsulta
  • ParentStatus: busca subtareas según el estado de los padres


Una alternativa es completar las subtareas con el estado del problema principal mediante la automatización, de modo que pueda usar estos metadatos en JQL estándar.

Por ejemplo...

  • Cree un campo personalizado, como una lista de selección (con las opciones de estado) o un campo de texto
  • Utilice la automatización para modificar el campo cada vez que se realice la transición del padre.


Háganos saber sus pensamientos!

0 votes
Charlotte Santos -Appfire-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 25, 2024

Hi @Jose Lago

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, natively, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to get all subtasks whose parents are closed:

issue in subtasksOfParentsInQuery("status = done")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 24, 2024

Hi @Jose Lago

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, this would be easy to do in the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available, including the parent status. This is how it looks in action:


As you can see above, you can easily sort and filter by the parent status, and also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

Any questions just let me know,



Suggest an answer

Log in or Sign up to answer