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

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 :)

Sam Hall Community Champion May 07, 2017

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Sunday in Agility

You asked for it, so we delivered: images on issues have arrived

A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...

278 views 3 11
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