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

Custom field for Issues

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?

1 answer

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.

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

Hi Lara!

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

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

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?

 

 image.png

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

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

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

Suggest an answer

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

How to create Jira issus from Excel file?

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...

4,528 views 22 32
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