I'm querying directly into the DB using the CHANGEGROUP and CHANGEITEM tables to create reporting on scope changes w/in sprints--i.e. stories added, removed, completed durring a sprint.
The major problem I'm having is solving for cloned issues that are retaining the parents sprint value.
This makes it look as though a story was removed from the parent sprint when technically a story within the sprint was cloned and that clone was moved to a different sprint.
Any ideas on how to solve for this?
I'm unable to just filter out all clones because there it a posibility that a story could be cloned and then left within the current sprint, right?