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?
Hello Henrik,
Is this custom field from an App?
Tables: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.Regards
Thank you.
Still cannot find the field with the values. We are talking about a select list. I have an Issue table and a Project table and a bunch more. Where should the customfieldvalue be stored? Is that a table on it's own?
I do see the custom field I'm after in the Fields table but that doesn't contain the actual values.
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
It looks like you're new here. Sign in or register to get started.
