How to get tickets list of what the backlog was for our JIRA project at a given point in time

[Lakshmi CH]

Hi Team,

Is there a way to get a snapshot of what the backlog was for our JIRA project at a given point in time? We're hoping to write a query for this to get quarterly data points going back the last few years and trying to figure out if that's even possible/how we might go about doing this.

[John Funk · Accepted solution]

Hi Lakshmi

Try something like: project = ABC and status was "BACKLOG" on 2023-04-01

That should show you every issue on that project that was in the Backlog status on April 1, 2023. Change the dates and status as needed. 

[Lakshmi CH]

Hi @John Funk ,

It worked. Thank You.

[John Funk]

Great! Glad it worked for you.