Get issues by sprint from database?

Daniel Luevano August 3, 2017

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.

1 answer

1 accepted

1 vote
Answer accepted
Boris Berenberg - Atlas Authority
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 3, 2017

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!

Suggest an answer

Log in or Sign up to answer