nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to find out were Custom Fields are used?

Marcel Plomp (inactive)

I've made a Custom field that has been configured as "Global (all issues)". The field is not used on a particular screen. It is only used in a workflow Post function.

By accident I've removed the field and then the post function did not work anymore.

How can I find were Custom fields are used in workflows and maybe other functionality in Jira that I'm not aware off? I want to clean up the custom fields which are not used.

(BTW: Workflow now works fine again thanks to my Database administrator )

Accepted answers

All comments

Peter Van de Voorde

Hi Marcel,

I don't think there is a quick solution for your problem.

It's not possible to see the usage of a custom field through the web interface.

It will probably be possible with some queries in the database.

Best regards,

Peter

Jobin Kuruvilla [Adaptavist]

The approach that worked for me best is to export the workflows into XML and then search the custom field id using a text editor. If you have numerous workflows, it is also not a pretty solution!

Using a few JQLs you can find isues where the custom field is populated and maybe find the workflows and screens associated with that project easily.

Marcel Plomp (inactive)

THX.

For queries in the database I'll turn to my database administrator. Most custom fields are not used in workflows, so I'll try to find if they are populated using JQL.

Mirek

Maybe it could be useful for someone in the future.. There is a plugin - https://marketplace.atlassian.com/plugins/pl.com.tt.admintoolsforjira.AdminToolsForJira that have custom field usage feature. It was very helpful for me to delete couple of custom fields without digging into database. You can give it a try.

Dalectric

SQL to find which workflows reference a customfield

select * from jiraworkflows wf where wf.descriptor like '%customfield_10281%';

Jonathan Hult

Two other add-ons:

Krzysztof Skotnicki

SELECT CF.cfname, count(CV.ISSUE) FROM customfield CF join customfieldvalue CV on CF.ID = CV.CUSTOMFIELD
group by CF.cfname

mysql

Divya Yathagiri Venkata

Hi,

This query didn't give any results for me. I am trying to get a list of projects where a couple of custom fields are being used.

The fields are being used in multiple projects but I can't export all the issues since there are too many issues to expect and it forbids me to export more than 10k issues.

Petru Simion [Simitech Ltd.]

For server - https://marketplace.atlassian.com/apps/1220239/config-insights-for-jira?hosting=server&tab=overview

For cloud - https://marketplace.atlassian.com/apps/1224298/config-insights-for-jira-fields-per-project?hosting=cloud&tab=overview