Find Story with all closed sub-task exept of specified sub-rask type

[Alena Samruk]

Hi,

I have issue type Story and two sub-tasks issue type Task and QA. Is there any way to find all Stories with closed Tasks but open QA issue?

[Mark Segall · Accepted solution]

Hi @Alena Samruk - Unfortunately, not natively.  You may be able to accomplish this with a 3rd party app like scriptrunner

[Alena Samruk]

@Mark Segall  thanks for the answer! Could toy please clarify how to do it with scriptrunner?

[Mark Segall]

Making sure I understand this a bit better.  Your comment is a bit misleading...

two sub-tasks issue type Task and QA

Task is its own issue type that is at the same level hierarchically as Story.  Assuming our "Task" is really "Sub-Task", you could do this with scriptrunner:

issueFunction in subtasksOf("(issueType = Sub-Task AND statusCategory = Done) AND (issueType = QA AND statusCategory != Done)")

Now, if Task/QA are really just standard issue types that are linked as children of the story you'll want to do something like this (Note - I'm using blocks, but you could go with something else):

issueFunction in linkedIssuesOf("(issueType = Task AND statusCategory = Done) AND (issueType = QA AND statusCategory != Done)", "blocks") 

[Alena Samruk]

@Mark Segall thanks for helping, it's work!