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

[Amit Kumar Singh]

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]

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 🙂

[Amit Kumar Singh]

Hi @Kai Becker 

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

[Kai Becker]

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 🙂