Currently I'm running the following query to retrieve update tickets from within a specific date range. I've tried it 5 different ways. However none of them seem to work.
I've resolved the issue. To overcome this problem you need to append the date range with Project name rather than &updatedDate>=startOfWeek(-1) AND updatedDate<=startOfWeek(-1) .
It should be project=XYXY%20AND%20updatedDate>="2018-11-25"%20AND%20updatedDate<="2018-11-30 along with quotes
This is my current query, 'https://url.atlassian.net/rest/api/2/search?jql=project=XYXY+order+by+updated&maxResults=10&fields=*none&updatedDate>=\"2018/11/01\" and updatedDate<=\"2018/11/31\"'";
It's giving HTTP/1.1 400 BAD_REQUEST error.
However without based on specific days, can we filter it by based on weeks. 1wk or 2wk.
Hi @Madura Bashana,
The 400 BAD REQUEST error gets for many reasons, some of them are related to the "Invalid URL" or "expired local cookie". Try to clear relevant cookies and then try.
Yes, you will be able to retrieve the issues based on the weeks also. You need to use the "startOfWeek()" parameter in the JQL filter. For example, if you want to retrieve the issues between last 8th week to 4th week here is example JQL.
updatedDate >= startOfWeek(-8) and updatedDate <= startOfWeek(-4)
This may help to get the results.
Kishore Kumar Gangavath.
Did that work for you ? Cause tried, it doesn't seem to work. I' ve tried it in two different ways,
2. https://url.atlassian.net/rest/api/2/search?jql=project=XYXY+order+by+updated&maxResults=10&fields=*none&updatedDate>=startOfWeek(-1) AND updatedDate<=startOfWeek(-1)
currently rather than running through this my script, i'm just manually executing the url
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