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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Tuesday in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

686 views 1 18
Join discussion

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