Get all assigned ticket between 2 dates

I would like to filter out all issues which were assigned to "XYZ" between 1st May to 5th May. 

Note:- assignee may be changed in between so i used 'was'

I wrote this query 

assignee was XYZ AND updatedDate < "2017/05/06 00:00" AND updatedDate > "2017/04/30 00:00"order by updated DESC

But, all is correct except this fails on one special case.

This is giving me those issues too which were assigned to me earlier before these dates --

because these issues may be updated in these dates range.

I could not sort it out as there is no such thing assignedDate in Atlassian, please sort this out.

"How to find all issues which are assigned to me between given dates ?"

 

 

1 answer

1 accepted

0 votes
Accepted answer

You could try something like:

assignee was currentuser() AFTER 2017-05-01 and assignee was currentuser() BEFORE 2017-05-10

It will still give you issues that had the Current User as assignee outside that date range if they had been assigned to that user previously. So you might further refine based on other criteria as you did in your own example.

e.g.: assignee was currentuser() AFTER 2017-05-01 and assignee was currentuser() BEFORE 2017-05-10 and updated > startOfMonth()

yeah, it will not solve the problem completely but now i have more refined result.

Thanks :)

You could use the 'WAS' operator with 'DURING' to simplfy:

assignee WAS currentuser() AFTER 2017-05-01 AND assignee WAS currentuser() BEFORE 2017-05-10

to:

assignee WAS currentuser() DURING (2017-05-01,2017-05-10) 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,711 views 17 21
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you