Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

8 answers

SQL to find which workflows reference a customfield

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

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.

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

mysql 

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

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.

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.

0 votes
Mirek Community Leader 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
TAGS

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you