Automate a daily report of issues that have a specific status change.

Question

Hi there,

I am looking for a way automate a daily report of issues/tasks/cards which have been deployed. For my team, "deployed" is a status AND at the moment a card hits that status a label "Deployed" is also assigned to the ticket. Note that this status is different from "Done".

Ideally this report would result in an exported list (csv, excel) or maybe even a table in Confluence (a girl can dream).

I've seen all sorts of ways to generate similar reports, but nothing on this subject. Any thoughts or advice?

Kate Turcotte_93l6ly · Answer

This more than helps Walter, Thank you!
I am experimenting with the filter subscriptions now to see what the daily email looks like.

Do you know - is there a way to amend the date the event occurred to the result? I am getting a list of the stories released per day as expected. Having the date it occurred will solve the problem of having to manually add dates to these reports.

Walter Buggenhout · Answer

Hi @Kate Turcotte and welcome to the Community!

All you need for this, is a filter that pulls in the data that had a status change to the deployed status on the previous day. As JQL supports history search on status changes, you should be able to use the following:

Project = "<Your project>" AND status CHANGED TO Deployed
DURING (startOfDay(-1), endOfDay(-1))

Save the filter and you will be able to:

* add a filter subscription to it that sends out an automated digest email
* add it behind a filter results gadget on a Jira dashboard
* add a Jira macro in Confluence and use the same JQL to display the deployed issues there

The suggested filter is dynamic, so it will always return the issues that were deployed on the previous day. You can play around with the numbers to report on multiple days or use fixed dates to return always the same results.

Hope this helps!