It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to query date range of created field using JQL and REST API?

I need to fetch all issues that was created between two dates with specified reporter.

For Example,

January 1, 2013 to March 15, 2013.

Here's the URL that I'm using for the REST API:

http://domain.com/rest/api/2/search?jql=reporter='ram'&created='2013/10/22'

Thanks in advance!

3 answers

Try

http://domain.com/rest/api/2/search?jql=reporter=ram and created >= "2013/01/01" and created <= "2013/03/15"

If that doesn't work, URL encode the parameters.

http://domain.com/rest/api/2/search?jql=reporter%20%3D%20ram%20and%20created%20%3E%3D%20%222013/01/01%22%20and%20created%20%3C%3D%20%222013/03/15%22

encoding works Thanks

works without encoding here. Thanks

Thanks, works perfect

works without encoding here. Thanks.

Both with and without encoding, its not working.

http://domain.com/rest/api/2/search?jql=reporter=ram and created >= "2015/02/09" and created <= 2015/02/11"

So when I searched the issues, I got to see the created time stamp format  i.e., "2015-02-09T11:44:22.000+0530".


Is this the issue with different time stamps, it got stored and retrieved?

 

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Calling all Jira Cloud users! Give us feedback on our exploration of a new navigation.

Hi everyone! My name’s Matt and I’m a product manager at Atlassian. I work in the navigation & findability space for all our Jira Cloud products. We’ve been working on trying to improve the exp...

770 views 8 12
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you