How can I get a list of all JIRA fields?

[Sergio]

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]

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

[Joe Pitt]

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

[Sergio]

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