scrumboard query

[Martijn van Riele]

Hi, i'm struggling with making the right scrumboard filter-query. I want to see all open story's and there underlaying subtasks. I now use:

Team = "Team Self Service" AND status not in (Closed,Done,Resolved)

The downsite is that i don't see subtasks with status Closed, Done or Resolved.

How can the query be formed so i only see story's that are still open but it shows all underlaying subtasks, no matter there status.

[Alexey Matveev]

Hello,

You would need an add-on like Adaptivist ScriptRunner or Power Scripts. If you have Adaptivist scrptrunner you could write a JQL quiery like this

(Team = "Team Self Service" AND status not in (Closed,Done,Resolved)) or (issueFunction in subtasksOf("Team =\ "Team Self Service\" AND status not in (Closed,Done,Resolved)"))

If you have Power Scripts then you could create your own JQL function(for example, subtasks.sil) with a code like this

string [] keys = selectIssues(argv[0]);
string [] ret;
for(string k in keys) {
   if (size(subtasks(k)) > 0) {
         ret += k;
   }
    
}
return ret;

And then you could call it like this

key in silJQLList("subtasks.sil", "Team = \"Team Self Service\" AND status not in (Closed,Done,Resolved)"

You can find more examples on JQL functions in Power Scripts here

https://confluence.cprime.io/display/TR/Advanced+JQL+Searches