Just a heads up: On March 24, 2025, starting at 4:30pm CDT / 19:30 UTC, the site will be undergoing scheduled maintenance for a few hours. During this time, the site might be unavailable for a short while. Thanks for your patience.
×can i get the database query to fetch the customfield name and its default value in jira
I assume you are looking for an SQL query. The table customfield has the name and id for the custom fields.
The table genericconfiguration has the default values
SELECT *
FROM customfield AS CF
JOIN genericconfiguration AS GC ON (CF.ID = GC.ID)
where GC.DATATYPE = 'DefaultValue'
@Norman Abramovitz : This Query will not give the actual default value which is set while configuring the custom field .
For e.g. Test1 is custom field and i have set default value for it is "abc".So how can i retrieve this custom field with defualt value as "abc" from Jira DB.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It has been close to six years since I wrote this response. Jira has different database schemas based upon the version you are using. I believe you can figure things out once you look at the appropriate schema.
https://developer.atlassian.com/server/jira/platform/database-schema/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Atlassian Government Cloud has achieved FedRAMP Authorization at the Moderate level! Join our webinar to learn how you can accelerate mission success and move work forward faster in cloud, all while ensuring your critical data is secure.
Register Now
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.