Get issues by sprint from database?

Daniel Luevano_ezwo3t

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.

Boris Berenberg - Atlas Authority

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!