How can I get a list of all JIRA fields?

S November 14, 2014

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.

2 answers

0 votes
WeAreAllJustinNow
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
January 15, 2015

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

0 votes
Joe Pitt
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 14, 2014

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

S November 14, 2014

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

Suggest an answer

Log in or Sign up to answer