You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Need your help in cleaning our jira instance. What is best way of finding empty/unused field. I am Using JIRA provided Custom field optimizer , but it won't count Archived issue or Archived project, for these it's showing zero issue count. What is the best way to find field which include both archived and active issues.
As you can see the screenshot, Last value update is 23rd Nov 2022 but issue is showing zero and jql query is also showing zero count.
I want to know which field I consider for deletion. Which is having issue count =0 or in which last value update is never ?
Kindly help me with parameters which i need to check before deleting any custom field.
Using sql query mentioned in this link, i can find field usage but I think it won't count Archived issue. My main concern is how to check field is used with archived issue or not. Please suggest
There has been a similar discussion on this topic in this Community Post.
You can refer to this Atlassian KB for more information.
Basically, you will need to execute this SQL Query to get the details:-
select count(*), customfield.id, customfield.cfname, customfield.description
from customfield left join customfieldvalue on customfield.id = customfieldvalue.customfield
where customfieldvalue.stringvalue is null
and customfieldvalue.numbervalue is null
and customfieldvalue.textvalue is null
and customfieldvalue.datevalue is null
group by customfield.id, customfield.cfname, customfield.description;
I hope this helps to solve your question. :-)
Thank you and Kind regards,