Which filter should be used to see all reassign tickets during last month for some specific user?

Karyna Grygorova February 19, 2024

Hey,

 

I would like to see which filter I should use to see how many tickets UserX got for some specific time and if I want to see multiple people. 

 I tried  this filter but somehow it should me not in specific time but during all the time

assignee was USERx during ("2024/02/02", "2024/02/20") ORDER BY updated DESC

 

Thank you!

3 answers

1 vote
Ravina
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 20, 2024

Hi @Karyna Grygorova If you looking for the specific time when the assignee of those ticket is a certain usersbased on the issue created time then the JQL query given by Sreedevi will be helpful,

But if you want a more refine search for the specific time then I would recommend to use the issue updated date instead of created data as sometimes issues are created long back where assignee of those issues is different but there are recent changes in the assignee of those issues that could be missed if issues searched based on the created date.

It will vary based on what your requirement is as sometime issue created date will help and if you looking for latest data then issue updated date will give you more refine results.

Please check the below JQL's for the same.

Below JQL is to get the issue where username1 was assignee of the issue which are updated between Feb  1, 2024 and Feb 20, 2024

assignee was username1 AND updated >= 2024-02-01 AND updated <= 2024-02-20 ORDER BY updated DESC

More multiple users you can use the below JQL and add as much as users you want to search separated by comma in assignee was in block



assignee was in ("username1", "username2", "username3") AND updated >= 2024-02-01 AND updated <= 2024-02-20 ORDER BY updated DESC

 Please try and let me know if you face any issues or need more details.

Thanks

Ravina

1 vote
Sreedevi Kr February 19, 2024

Hi,

You Can specify the created dates and use "in" operator and inside () give multiple users.

Below I have given some examples please check.

created >= 2024-02-02 AND created <= 2024-02-20 AND assignee in (user1, user2)

created >= 2024-02-02 AND created <= 2024-02-20 AND assignee was in (currentUser(), NMG8COB)

0 votes
Karyna Grygorova February 20, 2024

Thank you for your help

Suggest an answer

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

Atlassian Community Events