How to get all Custom field related details like Custom field Name,Type,Description and Context scope (Issuetype and Project)

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)

Dnyaneshwar Borase


You can find the Database Schemas here:

If you look for the CUSTOMFIELD table, you will find most of the information that you need.