Custom field for Issues

[Henrik Jacobsson]

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?

[laralg]

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

[Henrik Jacobsson]

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?

[Henrik Jacobsson]

I do see the custom field I'm after in the Fields table but that doesn't contain the actual values.

[laralg]

Hello Henrik,

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

[Henrik Jacobsson]

Hi Lara!

Yes this definitely helps although I cannot see any tables starting with 'custom' but maybe I'm missing permissions?

[laralg]

Hello Henrik,

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:

https://marketplace.atlassian.com/apps/1212248/home-directory-and-db-browser-for-jira?hosting=server&tab=overview

Best regards

[Henrik Jacobsson]

I am accessing Jira through an ETL tool, this is what I can choose from. So the ETL tool is not giving me access to the whole database? Any idea why this could be?

 

[laralg]

Hello Henrik,

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.

Sorry

[Henrik Jacobsson]

If I go throught your API instead, would I be able to get whichever table I want?

[Henrik Jacobsson]

Now I found what should have been the solution, there's a parameter, IncludeCustomFields, but when setting it to true it fails..