Join Issues to Sprints (on table AO_60DB71_SPRINT)

[Ana Raquel Lazarini]

Hi, everyone

I know this question has been asked here before but none of the threads I read solved my issue, so I'm raising this again (sorry)

I'm working with Jira 7.2 on an Oracle database. I need to query all the issues with their Sprints. I tried joining the jiraissue with the AO_60DB71_SPRINT table through the customfieldvalue (resulting on the query below), but it does not return any data. And, also, the Sprint ID I get on the Jira UI is different from the one that appear on the Sprints table.

SELECT s.id sprint_id,
       i.ID issue_id,
       cfv.updated updated_on,
       i.issuenum,
       i.created created_date,
       i.resolutiondate resolved_date,
       i.duedate due_date
FROM customfieldvalue cfv
INNER JOIN AO_60DB71_SPRINT s ON CAST(s.ID AS VARCHAR(10)) = CAST(cfv.stringvalue AS VARCHAR(10))
INNER JOIN jiraissue i ON i.id = cfv.issue
WHERE customfield = 10004

Does anyone know how can I join these tables, please?

Thanks so much!

Gratefully,

Ana Lazarini