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; } } }

JIRA: Scheduling a query and running historical reports

Allen Lai1

Wondering what the best way to report on tickets (bugs) that are unresolved for a given week. Right now, I run the following query every week:

status not in (Resolved) AND resolution in (Unresolved) AND issuetype in (Bug)

However, I have to run this query each week which I don't want to do. Also, I would like to get historical data (i.e. previous week), which I can't do unless I remove the Status and Resolution filter and then manually go through the list, which is too time-consuming.

Is there a way to A) schedule the query to run on a certain day and send it to me, and run a report so I can see historical "snapshots" using the same criteria as above?

Thanks!

Accepted answers

Joe Pitt

If you create and save a filter you can subscribe to it and it will email the results to you based on the schedule you set.

All comments

Rp Subhub

Receiving Search Results via Email

You can run historical reports on status like this:

status WAS NOT IN ("Resolved","In Progress") BEFORE "02/02/2011"

See Advanced Searching for more information.

Joe Pitt

If you create and save a filter you can subscribe to it and it will email the results to you based on the schedule you set.

Allen Lai1

This worked! But I had to use the "ON" predicate for it to work. Thanks!

Welcome!

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

Quick Links

Find more posts tagged with

jira

jql

report

automation

schedule