Best way to get a list of all unused custom fields data in Jira
Hi @manikanta ch
There's a really great Knowledge Base article on managing custom fields - see this page here.
Let us know if this helps or if you'd like any further suggestions
Ste
Hi @Ste Wright ,
I have deleted all unused screens and inactive workflows and i ran the below SQL query as mentioned in the article to rertive all unused custom fields but SQL query is not getting correct data. The fields list the Query listed is attached to screens and workflows. We want rertive the unused custom fields data which are not attached to any screens, workflows or used in any tickets.
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;
Could you please let me know if there is any other query to get unused custom fields data?.
Thanks,
Mani
Not sure on the query - but an alternative could be to use an app to clean-up your instance?
For example, apps such as Power Admin or Optimizer for Jira could be helpful here!
It looks like you're new here. Sign in or register to get started.
