Obtener el estado del padre

[Jose Lago]

Hola,

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

Muchas gracias

[Ste Wright]

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...

• ScriptRunner for Jira - you can also get search as a standalone App in Cloud
• JQL Search Extensions for Jira 
• JQL Tricks Plugin
• ...or another App from the Marketplace 

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!

Ste

---

---

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!

[Charlotte Santos -Appfire-]

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!

[Hannes Obweger - JXL for Jira]

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,

Best,

Hannes