Simple JQL

[Eric Guesdon]

Hi,

I have a project with few worktype.
One of them in a "BZF Integration Reserve". It has subtask.

Users ask me to build a list of all "BZF Integration Reserve" issues with their Subtask.

It's just not possible !

We sent Robots on Mars, the AI era started. But writing a JQL to get a list of worktype with all its sub-task... it's not possible.

Oups, it's in fact... you have to pay more and more and more and more... just to write a jql.

How to thank you ?

[Arkadiusz Wroblewski]

Hello @Eric Guesdon 

I get the frustration, but this one is actually simpler than it looks, and it’s not “AI tax”.

In Jira Cloud you can pull parent + subtasks in one filter. You just need to search by issue type + use the parent relationship.

Try this:

All parents (your work type):
project = XYZ AND issuetype = "BZF Integration Reserve"

All subtasks of those parents:
project = XYZ AND issuetype in subTaskIssueTypes() AND parent in (project = XYZ AND issuetype = "BZF Integration Reserve")

If you want both in one list:
project = XYZ AND (issuetype = "BZF Integration Reserve" OR (issuetype in subTaskIssueTypes() AND parent in (project = XYZ AND issuetype = "BZF Integration Reserve")))

Then in the results, add the Parent column and sort by Parent/Key so it looks grouped.

That’s the closest “single list showing parent + children” you’ll get in plain Jira search. If you want a prettier hierarchy view, that’s when apps (or Plans) come in but the basic list is doable with JQL.

Have a great Day.

[Marc -Devoteam-]

Hi @Eric Guesdon 

@Arkadiusz Wroblewski is correct here.

Otherwise there are options on the marketplace to provide you with possible options.

You could ook at JQL options:

https://marketplace.atlassian.com/search?query=jql&hosting=cloud 

[Enric Font]

In cloud you can't do jql like: 

parent in (project = XYZ AND issuetype = "BZF Integration Reserve")

[Marc -Devoteam-]

Hi @Enric Font 

Correct, this is mentioned by @Arkadiusz Wroblewski 

He provided an example on how to achieve this ootb, or you will need to look at 3rd party apps from the markeptlace.

[Arkadiusz Wroblewski]

@Marc -Devoteam-  Probably he referencing to that https://jira.atlassian.com/browse/JRACLOUD-67916 

And problems with referencing Subquery, but that doesn't changing a point, either he try multiple JQL Query, combine them ”Dirty way" or grab Addon.

The thing is we giving advices but User gived more his Pain out about that, and I doubting somebody who using Queries on this level don't have ScriptRunner for advanced JQL or other Addons.

[Enric Font]

Dear @Eric Guesdon 

In Jira Cloud this is not posible.

An alternative would be creating a filter with all the issues of the project. 

Then export it to an Excel file including the parent column.

Order the rows by parent, key

Hope this helps