How can I get a list of all JIRA fields?

Question

Hi all,

I need to get a list of all JIRA fields, including systm and custom fields.

Actually, I have found a way to get a list of custom fields from database:

select ID,cfname from customfield;

but what about system fields? How can I do this?

Many thanks.

WeAreAllJustinNow · Answer

You can run this query to get a list of all your fields per field configuration:

select fl.Name as `FieldConfiguration` , f.*
from fieldlayoutitem f
inner join fieldlayout fl on fl.ID = f.fieldlayout;

This was written for MySQL, so if you have another DB, you may have to tweak the syntax a little

Serge5 · Answer

Joe,
you mean fieldconfiguration table?
Tried to select all from this table but there is no "Affects Version/s", "Component/s" etc...

Joe Pitt · Answer

You can do it manually by looking the list of all fields in the field configuration and eliminating the custom ones.