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

Question

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.

thanks

David Fischer · Answer

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.

Pedro Paulo da Silva · Answer

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.

Pedro Paulo da Silva · Answer

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