Query to get (number of) issues with certain status at certain date

[Alen Dibra]

i require either a rest call (prefered) or a jql query to get all issues (or preferably the number of all issues) with a certain status (let's say done) at a certain date

example:

Issue         Status 01.01.2019   Status 01.02.2019  Status 01.03.2019
issue-1      open                       resolved                done

issue-2      resolved                  done                     done

issue-3      open                       open                     done

so a query for 01.03.2019 with status done should get all issues OR number of issues: 3
and a query for 01.01.2019 with status open should get issue-1 and issue 2 OR number of issues 2

Thank you 

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

Hi Alen and Welcome,

You can use the following JQL query:

status WAS IN (Approved, Done) ON 2019-01-01

Also you can use the api/2/search endpoint to get the data using a REST Call.

Let us know, if the provided information solves your doubts or you need further support,
Regards