Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

What table the JMCF custom field value is stored in jira database?

I am struggling to find the JMCF Transition Date/Time custom field value in jira database.

I tried in customfieldvalue table, but no way. I got others types but none of them were from third parties

I wanna write a sql to export my issues to my power BI model using PBI Data Flow.


2 answers

1 vote

Hi @Pedro Paulo da Silva 

JMCF offers calculated fields, which means that these fields are not stored but calculated on the fly (because their value can change at any time). You therefore won't find their value in the Jira DB (or anywhere else). They are, however, accessible through the Jira REST API, or through Jira DC's Data Pipelines feature, which is the recommended way to synchronize Jira with a data warehouse.

Hi David,

Thanks for replying. I knew calculated fields are not stored, but I was hoping to find others non calculated types like JMCF Transition Date/Time in database.

Unfortunaly, Data Pipeline is only for Data Center. My version is Jira server 8.20.2

Hi @Pedro Paulo da Silva ,

since Atlassian is retiring its Server products, you'll soon be migrating to a single-node DC license, which will make Pipelines available to you.

1 vote

Depends on the specific type of the field, and the content may be smeared across 1-4 tables too.

Your best option for reporting on JMCF fields, and other types, is to stop looking at the database and use the REST API, or use apps that understand it so you don't have to.

The database is a nightmare, and you're just making life hard for yourself.

Hi Nick,

Thank for replying. We already deliver analytcs services using API, but we are facing performance problems loading large volumes calling rest/api/2/search.  We also have EazyBI, but most of users work with power BI solutions.

We have succeed loading diretcly from database for years in our old tibco spotfire solution. Working with the tables was not a issue until we wanted to get some special types like JMCF Transition Date/Time.

Suggest an answer

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

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

71 views 1 3
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