Where is the Jira LABEL contents stored in SQL server

Question

Hi

I’m extracting data from the DBO.LABEL table for our reporting but it seems to be out of sync from the front-end tool. The front-end tool shows Jira Label for specific issues but in the table some issues are not even there. Do you know what could be the problem or am I reading a wrong table for the Issue Labels?

Matebese, S. (Sithembiso) · Answer

Yes it's joined on those 2 fields and the challenge is that some of the Issue Labels showing in the front end tool seem not to be stored in the DBO.LABEL table

Mohamed Benziane · Answer

Hi,

Make sure to join the issue.id from jiraissue and the issue in the label table.