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

rmhlg October 23, 2013

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

1 accepted

0 votes
Answer accepted
Ranadheer k February 11, 2015

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?

 

Bushra_Zubairi_dentalplans_com April 3, 2020

Did you ever figure out this issue. I am having the same issue

5 votes
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 23, 2013

Try

http://domain.com/rest/api/2/search?jql=reporter=ram and created &gt;= "2013/01/01" and created &lt;= "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

Mohamed Mahmoud October 28, 2013

encoding works Thanks

Hajder Rabiee December 10, 2013

works without encoding here. Thanks

Johan Moreno April 22, 2016

Thanks, works perfect

UGURCAN_CAYKARA March 11, 2020

Encoding works Thanks a lot ..

Aakash Chauhan March 21, 2020

Thanks for this.

0 votes
Hajder Rabiee December 10, 2013

works without encoding here. Thanks.

Suggest an answer

Log in or Sign up to answer