Filter for all issues with assignees attached to a project, outside the project

Question

Hello Community,

I am looking to set up a dashboard to assist in sprint planning for my particular project.  Part of this is setting up a gadget to show workload of the developers on one particular project, Foo.  Developers may also have assigned tasks on none or more projects Bar (one or arbitrarily more other projects).

Apologies in advance for any confusing wording

My question boils down to: What JQL would I use to get all items assigned to all developers in project Foo for all projects Foo and Bar

I have considered hardcoding the list of developers in, but I am hoping there is a way to do this programmatically for the very likely chance that the developer list changes.

Will Steele · Answer

Hello @Kristján Geir Mathiesen 
Thanks for the answer.  It's looking more and more likely that this will be the route I'll take.  It's not exactly what I'm looking for, as we would need to have our system admin update that group along with any roster changes we make to the project, but that may just be how it is ¯\_(ツ)_/¯

Kristján Geir Mathiesen · Answer

Hi @Will Steele

How about using a Jira or AD group (developers) and add all your developers to the group. Then you can use:

assignee in membersof("developers") and Project = foo

That way you only have to add new developers to that group (and not mess around with the filter).

Also, you can use a filter as a part of another filter, like:

filter = 34922 AND assignee = KGM

HTH,
KGM