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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.