It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL that will filter for a list of active projects with specified group members assigned

I am looking for JQL that will provide me with a list of unique projects (no duplicates) where:

  • There are active sprints (because I don't want to see inactive projects)
  • The assignees in those projects are members of defined groups (because I only want to see projects where my teams are working)
  • where the saved filter can be used in a Dashboard with the Filter Results widget

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[10020] 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).

 

Any input?

1 answer

0 votes
Stephen Wright Community Leader Sep 29, 2019

Hi @Jonny Chambers

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:

  • Projects: This lists a set of projects and their basic information. This is based on selecting projects rather than a filter so you'd need to search for those relevant and select them. 
  • Two Dimensional Filter: You could list the Projects on the Y-Axis using this gadget - and have another piece of information on the X.

Ste

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

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 ...

864 views 6 24
Read article

Community Events

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

Events near you