How to find out were Custom Fields are used?

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 :) )

7 answers

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


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,


1 vote

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.

SQL to find which workflows reference a customfield

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


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.

0 votes
Mirek Community Champion Aug 02, 2015

Maybe it could be useful for someone in the future.. There is a plugin - 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.


Suggest an answer

Log in or Sign up to answer
Community showcase
Published Wednesday in Jira

Make your Atlassian Cloud products more secure: our NEW admin security guide

Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...

45 views 0 2
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you