list of Fields used in a Jira Project

[CostaM]

Good day, I would like to run an extract off the Jira database to list ALL the Fields being used in a specific Project, as well as the Fields in the same Project that have never been populated.

Can anyone provide a suggested script that I can run?

thanks

[Vikrant Yadav · Accepted solution]

Hi @CostaM It's not recommended to run DB query for checking field on a project screen. 

You can check this document for getting the list :- 

https://confluence.atlassian.com/jirakb/how-to-list-all-fields-and-screens-in-use-by-a-project-in-jira-1115140601.html

I recommend you to use REST API for getting fields available on screen :- 

https://docs.atlassian.com/software/jira/docs/api/REST/9.6.0/#api/2/issue-getCreateIssueMetaFields

https://docs.atlassian.com/software/jira/docs/api/REST/9.6.0/#api/2/screens-getFieldsToAdd

Thanks,

Vikrant Yadav

[CostaM]

Thank you Vikrant