How can I get a list of fields used in JIRA?

Still need help?

The Atlassian Community is here for you.

Ask the community

Resolution

This query will list field information by field configuration.

SELECT fl.Name as `FieldConfiguration` , f.*
FROM fieldlayoutitem f
INNER JOIN fieldlayout fl on fl.ID = f.fieldlayout;

(info) This query is written for MySQL. You may need to tweak the syntax to get it to run in another DB.

Last modified on Feb 26, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.