Forums

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

How Can I found List of issued were assigned to assignee in last year?

Diana Kolestaneh
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!
July 11, 2018

My manager wants to know how many stories/issues have been worked on (assigned) to the person?

3 answers

2 votes
Jack Brickey
Community Champion
July 11, 2018

Hi Diana, welcome to the community. It depends on how you define "worked on". You indicated assigned but consider that an item could be assigned to someone w/o any effort applied and then reassigned. With that said, below is a start.

Go to Search for Issues and Advanced and enter the following JQL replacing my name w/ the individual in question.

(assignee = jack.brickey or assignee was jack.brickey) AND updatedDate >= 2017-01-01 and updatedDate <= 2017-12-31

 

you will notice that the JQL assumes that an 'update' equates to me doing some work. There are other and potentially better ways of qualifying actual work being done, e.g. time logged.

Thomas Deiler
Community Champion
July 11, 2018

@Jack Brickey, thanks I totally missed the "was" JQL command. Do you remember when this was implemented?

@Diana Kolestaneh,I stay with my advice( #1) not to do this for your boss. This will lead in most cases to the "blame game": Employee A has worked less than employee B. But was Jira all the time used as the one and only leading time tracking and work organizing tool? Really?

So long

Thomas

Aliaksandr Sasnouskikh
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!
October 27, 2021

Did that just to collect the work in which the employee was involved to recap it for myself and get prepared for the yearly review cycle. Thx for the command!

1 vote
Serhii Kibitkin_SAASJet_
Contributor
October 28, 2021

One more option is to create an annual filter with help of Dynamic Filters.

Screenshot - 

how-to-select-1-year.jpg

OR you can use Advanced search JQL query: assignee in(user1, user2,user3) AND created >= -360d AND project in ("QA testing project", Team46, "Object 12 project")

In this example, I've created annual created tasks for 3 guys for 3 projects during 1 year. 

JQL-use-filter-advanced.jpg

Honestly, it's better to control not only created tasks but execution time when the status was changed from to-do to in progress or in progress to review and more changes. In this case, it's better to use this tool - Time in Status 

0 votes
Thomas Deiler
Community Champion
July 11, 2018

Dear @Diana Kolestaneh,

  1. Tell your manager that this makes no sense, because he should not control his employees but trust them they do the right work.
  2. For just a simple query that tells you how many issues are assinged to a specific persion from right now to one year in the past use this JQL: assignee = person AND createdDate > -365d (but this will not tell you the issues that 'person' was assigned to an issue during its lifetime, but now isn't any more,)
  3. For complex things you have to call the Jira REST API. Go through all the history of the issues and search for an entry that 'person' was assigned during the whole issue lifetime.

I recommend #1 ;).

So long

Thomas

Jack Brickey
Community Champion
July 11, 2018

certainly agree w/ the fact that the data can be misleading!!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events