Database query for Custom field details like Custom Field Name,Field Type,Field Description,Field co

Dnyaneshwar Borase_ker2b1

Hi Team,

We need to help to get JIRA Custom field information details as mentioned below from the Database.

1. Custom Field Name
2. Field Type
3. Field Description
4. Field configuration Scope (Applicable contexts for scheme : Issuetype/Global (All Issues) or Project Specific)

Could you please guide us how do we get the data from the JIRA database?

It will be appreciated if you can share Database query (Database is MSSQL)

Regards,
Dnyaneshwar Borase

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

Don't try to do this, the database is not built for any form of reporting, and even if we told you where to look, I can guarantee you won't understand the data you extract properly.

Why are you trying to look at the configuration like this?  What is the reason behind the request?