directly read field values from database

[Uwe_Speckels]

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]

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]

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]

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