It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Is there a way I can see what issues have been added or removed from a sprint on a given day?

David Du Buron Oct 19, 2015

We have a customer who wants a daily report/query of activity of items being moved in a out of a sprints or back into the backlog for their project. I don't know why, but this is what I was told as an Admin. I responded with a jql query of "project = <PROJECT> and updatedDate > startOfDay()" and then you could sift through to see what actually changed on the Activity tab (for today at least, it wasn't a huge list), but I got some push back on that. Is there a more precise way of doing this? Basically see not only WHEN it was last updated, but filter on WHAT was updated within a certain date range? Perhaps JIRA-Agile has a history feature I don't know about already where it shows just sprint related activity?

 

EDIT:
I was given a little bit more background information for the use case. As bugs are being found and prioritized, they're removing stories from the sprint to make room. They reason they want to know about this is the customer has a separate bug tracker on their side which they are trying to keep in sync with ours.

So every time an issue is added or removed they want to know about it. They also want this as a daily or possibly weekly report so they know the latest movements. It would probably also be acceptable if they just had a chronologically sorted list of every thing that was added or removed, but it would have to be sorted by when it was added or removed.

3 answers

0 votes
Timothy Chin Community Leader Oct 19, 2015

We have a customer who wants a daily report/query of activity of items being moved in a out of a sprints or back into the backlog for their project

Isn't this the Burndown chart? But of course, the Burndown chart does not filter by date.

This is the Burndown chart REST call:

You can do any post processing you want with that.

 

David Du Buron Oct 21, 2015

No, sorry for not being clear. They don't want issues CLOSED in the sprint, they want issues moved from the sprint to the backlog. Meaning they were removed from the scope of the sprint. I was also given some more information from my PM, I'll add it to the original question.

0 votes
Pablo Beltran Nov 07, 2015

Try SQL for JIRA

The ISSUECHANGES table shows the activity of the issues (who did the change, when was it done, from old value to the new value, etc).

 

0 votes
Karla Ramirez May 01, 2018

any answer on this one?

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

741 views 7 0
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you