Where is the Jira LABEL contents stored in SQL server

[Matebese, S. (Sithembiso)]

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)]

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]

Hi,

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