Adding "assignees memberof" syntax to agile filter query grays out create sprint button

Anytime I add assignees to my filter query,  the "create sprint" button grays out.  As long as I leave it to "project = xxx AND fixedversion = xxx ORDER BY Rank ASC it will work.  Adding any kind of syntax regarding adding assignees even when narrowed down to a single person "assignees in (one_person)"  and that one person is the project admin within the project roles, the create sprint button grays out until i add him to the JIRA admins group long enough to create the sprint.  I remove him from JIRA admins and the sprint is created, but button is grayed out again.  Been looking and looking for best practices, known issues, etc regarding this.  Just curious if anyone has successfully added a non JIRA admin assignee to their filter query and "Create Sprint" button is still available.

1 answer

1 vote

That's very odd, and I can't replicate it!

As long as I have the clause "Order by Rank ASC" in the query, and I'm a project admin, it lets me create a sprint.

Could you confirm the exact queries you are using here (everything, exactly as it is, although feel free to change the name or key of the project, and the user IDs to Bob or something)?

Also, the version of Agile/Software, Jira, and also that you're working with a single project?

JIRA v6.3.9 Agile 6.7.4 Filter Query: (assignee in membersOf("dept_blah") OR assignee in membersOf(Dept_xyz) OR project = "blahblah") AND fixVersion = RELEASE123 ORDER BY Rank ASC When i remove the "assignee in" pieces, everything ok. If I add back either or both, create sprint button grays out unless its a jira admin, not project admin. Lastly, as described above, I used same syntax, except pointed it at the project admin as a test, "(assignee in membersOf(usernamexyz)), and create sprint grayed out again.

Very curious. However, that is a very wide board filter, and I suspect it might be something to do with the projects and the way the users narrow down which projects are in use. With your non-admin user, could you check what projects they have access to and amend the query again. Let's say you find they have project admin rights to projects AAA, BBB and CCC, then try changing the board query to ((assignee in membersOf("dept_blah") OR assignee in membersOf(Dept_xyz) OR project = "blahblah") AND fixVersion = RELEASE123) AND project in (AAA, BBB, CCC) ORDER BY Rank ASC You can guess the next bit - does the sprint button grey out then?

Nic, "Project In" did the trick.  Success using the following filter query:

assignee in membersOf(Dept_xyz) AND project in("project xyz") AND fixVersion = abc-R1 ORDER BY Rank ASC

Only problem now is that he'll have to maintain the filter adding new projects.  But no biggy, it works!

Thanks so much!

I thought it might be. What's happening there is that your user does NOT have the rights to start sprints in *every* project in the system. Your filter covers all projects, so they can't start the sprints until you narrow it to ones where they can!

Suggest an answer

Log in or Join to answer
Community showcase
Bridget Sauer
Published Wednesday in Agile

Community Showcase: Thomas Deiler, Mountaineering Agile Coach

Thomas Deiler is a Bavarian, Mountaineering, Senior Agile Coach. In this Showcase, you will learn about his journey from software engineer to project manager, his freelance philosophy, and much more....

106 views 4 6
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot