We recently moved to the Server version of Jira and am trying to extract data to load into our Data warehouse and cannot find the values associated with the custom fields we have setup and populated. I am betting it is stored in XML somewhere but nothing obvious has been found yet.
In fact it's in the database but I would advise you to prioritize using the REST API as much as possible.
If you need to keep using SQL, the table where information is stored is customfieldvalue (in the corresponding type column, you can join jiraissue table on issue ID and customfield on customfield_id).
Please note that if you're referreing to plugin data, they might use a proprietary format for storage or an Active Object table which is slightly different.
Hope this helps!
The Jira Software Cloud Team has been busy working on a simple, secure, and reliable way to integrate your build and deployment information from Jenkins with Jira Software Cloud. This means you don’t...
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