build a query to show story is done but sub-task is not

[zhangbinchao]

i want to build a query to show the status of story is "done" or "closed" but status of sub-task under this story is "start". what should i do?

[Thomas Schlegel]

Hi, you can't do that with plain Jira, because Jira does not now subqueries. Do you have the sricptrunner app? With that, you can define a subquery like that:

status in (start) and issuefunction in subtasksOf("status in (done, closed)")

[zhangbinchao]

Hi Thomas. thanks for your reply.  i just using advanced search in Jira. as you said, that means i can't get the result that i want?

[Thomas Schlegel]

No, unfortunately, you can't