Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Where is the Jira LABEL contents stored in SQL server

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?

 

labelss.PNG

2 answers

0 votes

Hi,

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

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

⏰ Day in the life of a Jira Admin!

Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...

754 views 2 21
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you