I'm going to start with "yes, I know that a sprint report is a click away in the JIRA interface," but I'm building a dashboard of other reports for our executives, using a third party reporting platform and I'm trying to find where in the JIRA database will show the issues that were added after a sprint started or if I just have to compare specific dates myself and which dates those would be. Does anyone have an idea on that?
in this thread has been answered how to fetch data and you can extra condition with time to add.
I had reviewed that thread, but as the proposed solutions did not answer the question, it seemed like it would be less helpful. I've gotten as far as the commenters, but I guess I was wondering whether there was a marker aside from a date comparison. I guess not, so I'll have to work that out.
I'm pretty sure I figured it out. I have to compare the date of the CREATED field in the changegroup table where the changeitem FIELD is Sprint, with the SPRINT start date. If the start date is earlier than the created date for the sprint change, it was added after the sprint started.
We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs