You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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?
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:
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!
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.