nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need JQL to get number of issues in particular status on a date

Jim Icenhower

Hi all,

I'd like to get the number of issues in a particular status (Backlog) on a particular day. The purpose is to get a report of the daily count of issues in Backlog status. I am executing this using the REST API. I have been able to see how many tickets changed status on particular day but I can't find the answer to how many were in a status on a particular date.

Thanks!

Accepted answers

You can use "was" to see how many issues were in a status on a particulate date.

Something like this

Status was in (Closed ) ON endOfDay()

All comments

You can use "was" to see how many issues were in a status on a particulate date.

Something like this

Status was in (Closed ) ON endOfDay()

Jim Icenhower

Thanks! That's exactly what I need.

Great!!! Please accept the answer by clicking on ✓ button before vote.

Roshan Patel_ubwms4

Is there a way to retrospectively see the number of Tasks with Status Backlog on x Date?

I am trying to see the number of items in backlog on a 4 week basis. To get it for todays date is fine but I would like to see over the last year how many there were etc, and if its going up or down.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jql

status