The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.