nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Simple JQL

Eric Guesdon_2qpepn

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 ?

Accepted answers

Enric Font_9rmi2h

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

All comments

Enric Font_9rmi2h

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

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_9rmi2h

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.

Eric Guesdon_2qpepn

agree ! It's why i called this post "Simple JQL".

From my perspective it's a shame for a solution like Jira.

Arkadiusz Wroblewski

@Eric Guesdon

Here I don't completely agree And not disagree, but view that in other sense. Atlassian expanding globally but many basic functions are forgotten which must be filled with external apps.

Problem lay too, some things lay deeper in code and are not Always so easy to implement as many thinks

@Marc -Devoteam- can say you about it more I'm myself couple years with Atlassian tools but still learning every day.

And we at AI expanse boom where unfortunately focus are primary on this functions 🫂

Feel your pain but it is like it is.

Have a great Day 🤠 ☀️

Bartek Szajkowski _ Orbiscend OU

@Eric Guesdon

Dear Eric,
Sorry for my late answer. I'm Bartek form Orbiscend OU.

If you are open for use third-party app, I would like to recommend our app ARGON.

This is exactly what Argon's childrenOf function is built for. Native JQL can't return both parents and their subtasks in one query, but Argon makes it straightforward.

Finds child issues (subtasks or issues with parent) of issues matching the specified JQL subquery - issue in childrenOf("subquery")

Example:

issue in childrenOf("project = SER and issuetype = Story")

This is combining a direct issue type filter with childrenOf using OR so the result includes:

All "BZF Integration Reserve" issues (the parents)
All their subtasks (the children)

issuetype = "BZF Integration Reserve" OR issue in childrenOf("issuetype = 'BZF Integration Reserve'")

ARGON you can find on Marketplace ARGON Powerful JQL Search

I hope that thanks to my answer, you will find the perfect solution for yourself.

Greetings and have a nice weekend

Bartek Orbiscend OU

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud