I have a custom field that imports data from another database. I need to find out what the data looks like in JIRA. Are 0 stored as Null or 0?
I have tried with out success to get the information out of JIRA which is on a MySQL DB.
Can someone share the query to achieve this?
I believe the answer to your question is going to be NULL. Depending on what information you're looking for, here is the database schema for JIRA.
You can use it to create queries and determine how the database is layed out. In addition, at the top of that article is a jar file depending on whether you're using JIRA 5,6 or 7 to generate schema information for the JIRA database. Here is the one for JIRA 7: jira-schema-diagram-generator-plugin-1.1.0.jar.
Every issue has an entry in the JIRAISSUE table with its own numeric id.
Likewise, every custom field is represented as a row in the CUSTOMFIELD table with its id.
There's an intermediate table between both of those tables named CUSTOMFIELDVALUE, each of which rows contains one issue id, one custom field id, and the stored value:
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot