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

3 votes
Answer accepted
Melo
Community Champion
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.)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
TAGS
AUG Leaders

Atlassian Community Events