How to get the customfield "default value" value using SQL query

aarti rajput_jpqh0n

I am successfully capture the data from two tables as required but still am not able to get the default value of custom field which is initially set at the time of field creation.

Query:

select cf.ID "Custom field ID", cf.cfname "Custom field Name", cf.defaultvalue "Default Value",
TRIM('com.atlassian.jira.plugin.system.customfieldtypes:' from cf.CUSTOMFIELDTYPEKEY) "Type", cfd.customvalue "List of values"
from customfield cf JOIN customfieldoption cfd ON cf.ID = cfd.CUSTOMFIELD
where cf.CUSTOMFIELDTYPEKEY LIKE "%multiselect%" OR
cf.CUSTOMFIELDTYPEKEY LIKE "%select%" OR
cf.CUSTOMFIELDTYPEKEY LIKE "%radiobuttons%" OR
cf.CUSTOMFIELDTYPEKEY LIKE "%checkboxes%";

 

Its giving me the below output: Where Default value for all custom field is NULL. it should give the exact default value which is set at the time of field creation.

Custom field ID	Custom field Name	Default Value	Type	List of Values
10112	Initiative	NULL	select	Yes
10117	T-Shirt Size	NULL	radiobutton	XL
10117	Size	NULL	multiselect	L

Dave Theodore [Coyote Creek Consulting]

Why wouldn't you do this in the REST API? It's designed to do this. You can also use the Jira CLI, which makes things even easier.

I would highly recommend not connecting directly to the database for this sort of thing. First, as you have already discovered, the data model is challenging. Second, any script you write has the potential to break when you upgrade, as the schema often changes with a new Jira version. Unlike the database schema, the REST API doesn't change from version to version.