Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Can you save a list of values to reference in a JQL search/filter?

andystrubhar February 25, 2020

Hi, I am looking for a way to save a list of values- e.g. usernames, so that I can reference it in JQL filters. If I can create a list of all the usernames on my team, I can use it in multiple filters but only update one place as my team changes. Thanks so much.

2 answers

3 votes
Jack Nolddor _Sweet Bananas_
Atlassian Partner
February 25, 2020

Hi @andystrubhar 
Definitively, @Payne is a really good "trick".

In addition to the answer, I would like to point out some others alternatives:

If your Team is grouped in some way, you can use the membersOf() JQL function to retrieve users under a similar group.

 

Search for issues under LATAM project assigned to users within the ios-developers group

project = "Latin America" AND assignee IN membersOf("ios-developers")

 

Moreover, you can also look for your team by using some functions provided by third-party applications, i.e. JQL Booster Pack provides you with some user-related jql functions (among others) that can help dealing searching for issues assigned / created / ... by users if they have something in common such as a user property, a project role...

See user-related JQL Functions provided by the above complement:

 

Hope this helps,
Best wishes

andystrubhar February 27, 2020

Jack, thanks for the response. This looks like almost exactly what I want, can I create a custom group some way? Might be an elementary question but I couldn't find it in a quick search. Thanks so much.

Jack Nolddor _Sweet Bananas_
Atlassian Partner
February 27, 2020

Hi Andy,

Note that only Jira Administrators can create groups and manage group memberships. See Managing groups page for further reference.

 

In the other hand, if you are a Jira Project Administrator, you can use an existing role within your Jira instance and manage role membership yourself using this in addition to membersOfRole() third-party function will do the trick as well. See Managing project roles page to learn how to manage role memberships.
Nota that creation of new roles can be only done by Jira Administrators as well, but project administrators can manage memberships of existing roles as previously pointed out.

 

Regards

3 votes
Payne
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 25, 2020

One way is to create a filter for your team, e.g.

assignee in (bsmith, rmoore, jpowell)

and save it, e.g. "Assigned to my team"

You can then reference that filter in any JQL query like this:

project = BR and resolution is empty and filter in (17600)

You can get your filter's ID by hovering over its link in various places.

andystrubhar February 27, 2020

Thanks for the answer- this is what I currently do. I was wanting some way to keep just that (bsmith, rmoore, jpowell) list somewhere so that I can reference assignee in(x) or reporter in(x) or similar. That way as the team changes I only have to make changes to one list. Any ideas is this is possible?

Like # people like this

Suggest an answer

Log in or Sign up to answer