I am looking for JQL that will provide me with a list of unique projects (no duplicates) where:
I have this JQL written up:
(assignee in membersOf(IO) OR assignee in membersOf(GISA) OR assignee in membersOf(CC)) AND issuetype = Story AND Status in ("In Progress", "To Do") AND cf in openSprints() ORDER BY project
This gives me a list of all stories that are in active sprints for 3 teams - IO, GISA, CC.
When I use this filter in the Filter Results widget in a Dashboard, I get a repeated project label for every active story, even if I only specify the Project field.
I then tried this JQL as a filter:
(assignee in membersOf(IO) OR assignee in membersOf(GISA) OR assignee in membersOf(CC) ) AND issuetype = project
... but that yielded no results. Plus I am unsure how to only filter these projects for ones that contain active stories (In Prog/ToDo).
The "filter results" gadget shows a list of issues based on a filter - not projects. So changing the JQL won't resolve that.
I don't think there is anything wrong with your JQL - the second version would only work if there was an issue type of "Project" - I assume you're talking of actual Jira projects rather than a custom issue type you've created?
You'll need to look for an alternative to list the projects - such as:
Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events