Capturing "default" custom fields?

[LarryBrock]

My organization is interested in capturing the "default" list of fields.  This is the list of fields created by the application install itself plus all the fields created during app installs.  This list will then be used to compare with a list of 3,200 custom fields that needs serious cleanup.  Looking for the API call that'll return said list, if one exists, or a sql call to the DB that can do it.  Thank you for your feedback!

[LarryBrock · Accepted solution]

I have been unable to formulate an API or direct database query that will capture all the fields one may see on an issue and have instead captured them manually from the view issue screens.  This was a terribly cumbersome process and I highly recommend starting with the pages posted by the one and only Rachel Wright, validated for your particular version(s) of the Jira product family.

[David Laperle · Accepted solution]

Hi Larry,

it seems you could use GET /rest/api/2/customFields API endpoint to list all customfields and filter them.

Example looks like this :

{ 
"id": "customfield_10000",
"name": "New custom field", 
"description": "Custom field for picking groups", 
"type": "com.atlassian.jira.plugin.system.customfieldtypes:grouppicker",
"searcherKey": "com.atlassian.jira.plugin.system.customfieldtypes:grouppickersearcher"
 }

 it would require some investigation, but my guess is that Atlassian fields aren't listed as "customfield_XXXX" and the "type" should be leverage to determine that as well.

Sorry I don't have an exact answers for you, but that would be how i would approach that issue.

[LarryBrock]

Thank you @David Laperle !  Was working with this query already but looking to enhance it to capture System fields in order to get a comprehensive list.