What's the best way to automate this report?
I'm trying to figure out a way to automatically generate this report -- it's essentially a snapshot of the sprint for our client (who rarely logs into Jira, and prefers this daily email after our standup).
It's essentially a quick snapshot of our board, with counts in each category. I do this because it gives everyone on the team a quick idea of what's in the pipeline, manages scope creep (Total # of tickets at the beginning of the sprint vs Current), and helps all the team members focus on their responsibilities.
Currently, I manually create this table and input all the tickets at the beginning of the sprint, then move each day but it's consuming too much time.
In an ideal world, I'd love to have this emailed to me automatically, but I'm ok with being able to run something from the command line or through a simple web app.
For reference, my query on the To Do column looks like this:
project in (project_name1, project_name2) AND status = 'To Do' AND Sprint in openSprints()