Rest API Filter based on created or updated date

[Joseph]

Can you please explain how to fetch all the issues based on created/updated date and time?

for example:

https://jira.com/rest/api/2/search?jql=status="In+Progress" and createddate>2020-04-20 06:43:23

also I need created date and updated date in the result.

Thanks.

Joseph

[Daniel Ebers]

Hi Joseph,

welcome to the Community!

When searching through JQL you can select several columns in Issue Navigator to choose which information you want to see (f.e. "Created", "Updated" and so on).

For the query itself it is absolutely possible to filter for date related parameters.

I recommend the YouTube videos on the official Atlassian YouTube channel, JQL searched by date are for example explained here: https://www.youtube.com/watch?v=Xl1P98DdbH0

If you prefer written documentation this is also available.

If your query should not succeed please provide details here so a Community members is able to help debugging.

Cheers,
Daniel

[Nicholas Riley]

Just working on something similar where I want to grab all records that have changed/new in the past day you can simply call it doing the following
updated>-1d you could also do the same using created.

https://jira.com/rest/api/2/search?jql=updated>-1d

Then to not have to wade through a tonne of JSON clean up your search results to return what you actually need by adding fields.

https://jira.com/rest/api/2/search?jql=updated%3E-1d&fields=Key,summary,duedate,timespent,aggregatetimespent,status,project,updated&startAt=0&maxResults=100