Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How to create a list of users that I can query in JQL?

Michael Crisanti
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 3, 2024 edited

Hello all! Trying to write a JQL query for a filter that will be linked to a dashboard. It needs to pull all tickets created by any user who is in my department. The dashboard will require multiple filters with variations of the same query (different queries will look at different date ranges depending on the age of the ticket), so listing out every user within the query for every one of the filters would get messy. It would be significantly less work to maintain just one list of users, instead of having to update each individual query anytime someone leaves or enters my dept.  This is my theoretical query:

Project = "Project_Name" AND status = "To Do" AND reporter in membersOf(My_Department) AND created < -6d AND created >= -8d ORDER BY Created DESC

How do I create the "My_Department" list so I can have all my department members listed there, and generate multiple queries referencing that one list?

(Note: I am not talking about creating an admin group. I've tried and am unable to use that feature. Hoping there is a different way to accomplish the same thing.)

1 answer

0 votes
Michael Crisanti
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 3, 2024

Did a little more digging and found this thread: https://community.atlassian.com/t5/Jira-Software-questions/Can-you-save-a-list-of-values-to-reference-in-a-JQL-search/qaq-p/1310323

Suggestion by @Jack Nolddor _Sweet Bananas_ seems viable. Going to try using role management to create a list of users I can reference in the query.

 

Capture.PNG

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.

Learn more
AUG Leaders

Upcoming Jira Events