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.
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
You can do it manually by looking the list of all fields in the field configuration and eliminating the custom ones.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.