How can we find/pull list of custom fields with their IDs one project or one issue type

Question

How can we find/pull list of custom fields with their IDs one project or one issue type only.

i need to pull all filed name with their IDs of all the issue type of my project.

i know how to get customFieldId one by one, but for more 100 fields, it will take time.

Example:  Fiels Name = XYZ, customFieldId=16054

Kai Becker · Answer

so the following SQL will return a list of all custom fields with their name and and id:

SELECT id, cfname FROM customfield;

If you want to get a list of fields used in a certain project, here is an article with a more complex sql statement to gather this information:

https://confluence.atlassian.com/jirakb/how-to-export-list-of-all-custom-fields-used-in-a-project-with-their-options-1115137872.html

Hope this helps 🙂

Amit Kumar Singh · Answer

Hi @Kai Becker

I need to pull the details for custom fields names with field ID and for one of the projects.

Kai Becker · Answer

Hi @Amit Kumar Singh

thanks for your question. I think the best way would be to get the data directly from the database.
But I'm not a 100 percent sure would exactly you need, as you are asking for custom fields, issue types and projects in combination.

Do you just need a simple list of issue types with id and name? Maybe you could explain a little bit more 🙂