Is it possible to search with JQL for a sub-task where all the other sub-tasks of a parent task except the one being searched for have the status 'closed'?
For example, I have the following structure of issues
- Parent Task1
---Sub-task 1.1 - 'Label1' - Closed
---Sub-task 1.2 - 'Label2' - Open
---Sub-task 1.3 - 'Label3 - Open
- Parent Task2
---Sub-task 2.1 - 'Label1' - Closed
---Sub-task 2.2 - 'Label2' - Closed
---Sub-task 2.3 - 'Label3' - Open
So I want to find that sub-task 2.3. Is it possible with JQL?
Just in case you are using Structure add-on and have this hierarchy as a structure, you can use S-JQL filter like
[status = Open] AND NOT (sibling of [status = Open])
Or, if you need it in a JQL statement somewhere,
issue in structure("my structure name", "[status = Open] AND NOT (sibling of [status = Open])")
Let me know if you need further help with this!
When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event