Customfield with default values

[Avdhesh Chauhan]

How to find the list of customfileds where defualt value is set and context is global

Im using MSSQL DB

can some one plz help

[Zul NS [Atlassian] · Accepted solution]

This might give you some pointers https://developer.atlassian.com/display/JIRADEV/Database+Schema#DatabaseSchema-Customfieldconfigurationdefaultvalue

[vkharisma]

Hi there,

I believe it should be under customfield value:

select id, cfname, defaultvalue from customfield;

Please modify the above SQL to suits SQLServer

Hope this helps!

Cheers, Vicky.