Sprint ID from AO_60DB71_SPRINT does not match the IDs on CustomFieldValue

[Ana Raquel Lazarini]

Hi, guys

I did some search and found out that the Sprint ID from the table AO_60DB71_RAPIDVIEW should be found on the table customfieldvalue (field stringvalue) so that I can join issues with sprints.

However, although the IDs I get from customfieldvalue match the ones I get from Jira UI, they do not match the ones on AO_60DB71_RAPIDVIEW.

Does anyone know how can I solve that?

Thanks so much in advance

Gratefully,

Ana Lazarini

[Nic Brough -Adaptavist-]

It's really not that simple.  I would stop trying to read the database and try to do whatever you are trying to do via supported routes.

Could you explain what you are trying to report on?  And why you're not using the REST API to do it?