The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

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

How can I find past assignees to a JIRA issue using JQL?

absy92
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!
May 10, 2022

I need to create a JQL which displays the past assignee to an issue.

I tried using the following query : "project = "Project Name" and issuetype in (Bug, Story,"Any issue type") AND assignee was @assigneename

but what if we don't know the assignee name what would be the query that would give me the similar data?

2 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

3 votes
Answer accepted
Melo
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 Champions.
May 10, 2022

Hi @absy92 ,

You can try using "assignee was not in ("known users") and assignee is not EMPTY"

Cheers,

Melo

absy92
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!
May 11, 2022

Thank you @Melo this does the job thank you!

If we are unaware of the assignee names or user names is there a way to get the data where I see the list of issues and their past assignee details.

Like Melo likes this
1 vote
Levente Szabo _Midori_
Atlassian Partner
January 5, 2023

@absy92 

I'd like to call your attention to a default report in Better PDF Exporter for Jira that creates an assignee history of an issue. It makes it easy to overview past assignees of an issue without figuring out the JQL query or any other difficulty.

See this tutorial blog on Jira assignee history.

20221212-jira-cloud-report-by-assignee.png

(Please note that Better PDF Exporter is a paid and supported app and I'm part of the team developing it.)

DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
TAGS
AUG Leaders

Atlassian Community Events