I am currently extracting data from Jira to our BI-system. We have a custom field connected to a specific issue where the customers name goes. This field is not included in the Issue table. Does anyone know where I might find this variable?
Is this custom field from an App?
jiraissue stores the issue information ( system fields mainly, status, etc...)
project because the jira issue only has an id and the issue number, you need this to know in which project.
customfieldvalue, is usuarlly where all the information of the custom fields is stored in Jira database, in order to get the information you will need information from customfield and customfieldoption if we are talking about select lists.
If it is a Select list.
In the table, customfield you have the id of the customfield.
In the table customfieldoptions you have to options of that customfield (if it is a select list, or a cascade select list)
In the table customfieldvalue you will have the value of the customfield in the issue, but you will not have the value as a string, you will have the value that shows in the customfieldoption.
Search in the table customfieldvalue for the id of the issue and the customfield and then you will have find the right name in the custom field option.
Hope that helps
Thats weird, if you can go into Jira database you should be able to see them 100%. I do not now about your database permissions but, there is an addon that lets you browse the database from Jira. So maybe you can look for what your are looking for without having to go into the database:
Jira's database has more than 100 tables, that sometimes are hard to follow, so I imagine your ETL is transforming data somehow to make it more "readable".
From what I see I would look into issues, fields and maybe issuechangelog, but I do not know what you have in those tables in your tool.
You will have to ask for access to Jira database or how they are transforming the data.
When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...
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