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

[Karyna Grygorova]

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!

[Ravina]

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

[Sreedevi Kr]

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)

[Karyna Grygorova]

Thank you for your help