You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
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
How finicky, I got it to work with
updatedDate>="2018-11-25"%20AND%20updatedDate<="2018-11-30"
without the project
TY
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Madura Bashana,
I have tried with the above URL and I'm able to retrieve the JQL results.
Can you please verify the domain of your site and check the permissions to view the issues.
Regards,
Kishore Kumar Ganagvath.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Mine doesn't work, However i can retrieve data through that query, but not related to the mentioned date range. For example if i want only between 2018-10-01 and 2018-10-30 it only has results with 11th month.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Madura Bashana,
Use your system date formate in the JQL filter. For example: updatedDate >= "2018/10/01" and updatedDate <= "2018/10/31" (dont forget the quotes).
If it's not working then share us the error message.
Regards,
Kishore Kumar Gangavath.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @[deleted]
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Regards,
Kishore Kumar Gangavath.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey@[deleted]
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.