Hi,
I need to create our own reports based on JIRA and JIRA agile. Part of my report is in Agile sprint report, but I need to add more information to that and for that I need to know sql quesries.
I need to get from database:
Thanks a lot
Community moderators have prevented the ability to post new answers.
issues were completed in sprint
sprint in closedSprints() and resolution != Unresolved
which wasn't and were moved to backlog.
sprint in closedSprints() and resolution = Unresolved
i did sprints in epic select, but still looking for somebody who will tell me how can I find information which issues were completed in sprint and which wasn't and were moved to backlog.
Any help will be a much appreciated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This previous answer might assist you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
it's great but I still do not know how to get all issue completed in sprint.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Community moderators have prevented the ability to post new answers.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.