Show issues on assigne for the certain period of time

[Artem Sinitsyn]

Is there any chance to view the issues which has been assigned to the user on a certaind period of time?

We need to make a report on how many tasks have been on the user per week (including the resolved and yet to be resolved).

Many thanks!

[Bharathi · Accepted solution]

Hello @Artem Sinitsyn,

Can you try one of these:

assignee WAS "abc@xyz.com" DURING (2022-08-01, 2022-08-08) AND updated > -1w

assignee WAS "abc@xyz.com" AFTER 2022-08-01 AND assignee WAS "abc@xyz.com" BEFORE 2022-08-08 AND updated > -1w

Without the "updated" clause, the query results cannot be controlled for a timeframe.

Hope this helps!

Thanks!

[Artem Sinitsyn]

Works like a clockwork. Thank you so much for the help!

[Trudy Claspill]

Hello @Artem Sinitsyn 

Welcome to the community.

You can create a filter for 

Assignee WAS <user> DURING(<startDate>,<endDate>)

Refer to

https://confluence.atlassian.com/jirasoftwareserver0822/advanced-searching-operators-reference-1142432460.html#Advancedsearchingoperatorsreference-WASWAS

[Artem Sinitsyn]

Hey @Trudy Claspill 

Doesn't seem like this is the thing I need. This shows all the tasks, including the old tasks which have been resolved long time ago. Probably, rule 'not in' might help, but I'm not sure how to write the proper filter for sorting the data.

[Trudy Claspill]

Please show the query you used.

You asked only about if a user was assigned to an issue during a time period. You didn't say anything about additional criteria that had anything to do with when the issue was resolved. What are the additional criteria?

[Artem Sinitsyn]

I will try to explain in more details :)

I need to filter the issues which have been solved, in progress and yet to be resolved. But "was" assigne shows all the issues (like 2-3 years ago, which are not relevant now). So is there Syntax to cut off them by any certain dates?

Hope this clarifies something.

Thank you