can i get the database query to fetch the customfield name and its default value in jira

[Sriveni Kokkonda]

can i get the database query to fetch the customfield name and its default value in jira

[Norman Abramovitz]

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'

[aarti rajput]

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

[Norman Abramovitz]

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/