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

This widget could not be displayed.

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

This widget could not be displayed.

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.

This widget could not be displayed.

SQL to find which workflows reference a customfield

select * from jiraworkflows wf where wf.descriptor like '%customfield_10281%';
This widget could not be displayed.
SELECT CF.cfname, count(CV.ISSUE) FROM customfield CF join customfieldvalue CV on CF.ID = CV.CUSTOMFIELD
group by CF.cfname

mysql 

This widget could not be displayed.

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.

This widget could not be displayed.
Mirek Community Champion Aug 02, 2015

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.

 

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

84 views 1 0
Join discussion

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