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!
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
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.