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?
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")
We know that great teams require amazing project management chops. It's no surprise that great teams who use Jira have strong project managers, effective workflows, and secrets that bring planning ...