Hi,
I already read this post:
https://community.atlassian.com/t5/JIRA-questions/Get-issues-by-sprint-from-database/qaq-p/422957
But unfortunatelly didn't work for the version I have (7.2.3)
This is the scenario:
The instance was updated from 6.4.9 to 7.2.3 and after that the custom field value for the Sprints stop been populated, I still see the Sprint value on the issue on the UI, but when I try this query:
select * from customfieldvalue where customfield = 10004 and issue =46659
I have 0 records.
I'm not sure if the Sprint info is stored now on a different table or what's going on.
I don't know the answer off the top of my head, but I can empower you with how to figure it out for yourself. You can enable SQL logging: https://confluence.atlassian.com/jirakb/how-to-enable-detailed-sql-logging-in-jira-665224933.html Then put an issue into a sprint, then disable logging, and look in the logs to see what INSERT statements occured. Best of luck!
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.