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