directly read field values from database

Question

Hello community,

I have to read several jira fields directly from the database. For one field I'm getting problems because I don't know how I can read the "sprint"-value.

My basic table is the "jira.jiraissue". Who can tell me which select of joins/unions I have to take to get the "sprint"-value. Every issue will be solved in a sprint.

Thanks.

Uwe_Speckels · Answer

Further, I analyzed the other tables and I found out that my search sprint was stored in the tables:

AO_60DB71_SPRINT

USERHISTORYITEM

Uwe_Speckels · Answer

Hi, thanks for your hint. I've already read the both tables but I can't get the value. Do you know if there exists another table with sprint values?

Alexey Matveev · Answer

I guess you would need to join customfield, customfieldvalue and AO_XXXXX_sprint.