How to find out custom fields mapped to a project?

Question

Hi Team,

Is there any way we can find out what custom fields are part of each project through jira UI or SQL query?

Arjun Hazari_o66ve4 · Answer

How about the fields on tickets which are hidden due to issue security schemes?

Ravi Sagar _Sparxsys_ · Answer

Hi @Vineela Durbha

Not very straight forward but possible.

* Take a look at the Jira database scheme.
* Fetch issue type screen scheme association with projects
* Fetch Screen scheme association with issue type screen scheme
* Fetch Screen association with fields (and 
* Find fields used in workflows (and few more joins to get the projects)
* In the some of the queries you can filter further based on applicable contexts as well.

..and I am sure I missed something but if you look at the schema then in few hours you can write these queries. I prefer dumping the output in Excel and not create too many joins, which makes it difficult to get the results especially from a big instance.

You can either run these queries directly on database (please not on production) or use ScriptRunner to execute SQL using Groovy from the console.

Or you can write Groovy scripts to fetch the same information using Jira Java API.

Sorry I don't have SQL queries to share at the moment but I hope it was helpful.

Ravi

Kinnera [Appfire] · Answer

Hi @Vineela Durbha

If you're a Jira Admin you will be able to see the custom fields here  Cog-wheel icon -> Issues -> Custom fields

Please click on that and filter the Projects to find out which custom fields are used in the projects or you can also see the projects in the Available Contexts column where the custom fields are associated to those specified projects.

I hope this will help you!

Thanks

Kinnera