Hello,
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?
Hi Andrey!
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!
Igor
Hi Igor,
Yes we are using Structure here.
I have tried it and it works just as we need.
Thanks a lot for the help!
Andrey
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Great! Happy to help.
Igor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It is not possible out of the box. I think you would need to write your own JQL function with Power Scripts, ScriptRunner or your own plugin.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
Have you tried project = "PROJECT NAME" and type = Sub-task and resolution is EMPTY ?
this will list all open subtasks in your project.
If you want just the list under specific parent ticket try:
Resolution is EMPTY AND parent in (ISSUEKEY)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.