How to get unused the options of custom field

[xu zhijian]

Hi All,

I want to find which options of one custom field are not used by issues , and i get one function is like "issue Object getCustomFieldValue(CustomField customField)", Do we have any other way to fetch the unused options besides to search in all issues ?

[Dieter · Accepted solution]

You would have to loop through the options and for each option you can get the list of issues having this option value using this method

http://docs.atlassian.com/software/jira/docs/api/latest/com/atlassian/jira/issue/customfields/impl/MultiSelectCFType.html#getIssueIdsWithValue(com.atlassian.jira.issue.fields.CustomField,%20com.atlassian.jira.issue.customfields.option.Option)

This could be faster than looping through the issues and calling getCustomFieldValue if you don't have so many options but a large number of issues

[Dieter]

The method is defined in interface http://docs.atlassian.com/software/jira/docs/api/latest/com/atlassian/jira/issue/customfields/MultipleSettableCustomFieldType.html

Please check the link which custom field types implement it

[xu zhijian]

thanks for your information .

[xu zhijian]

Hi Dieter, I'm wondering how to create a MultipleSettableCustomFieldType Object to call the mothod "getIssueIdsWithValue", when i use

MultipleSettableCustomFieldType mc = (MultipleSettableCustomFieldType)ComponentManager.getComponentInstanceOfType(MultipleSettableCustomFieldType.class);

for(Option op : opt)
{
  if (mc.getIssueIdsWithValue(cf,op).isEmpty())
   unusedOpt.add(op);		   
}

"mc.getIssueIdsWithValue(cf,op).isEmpty() " will cause a java.lang.NullPointerException. Thanks .

[xu zhijian]

I've found the solution like this :

CustomField cf = getCustomField();

CustomFieldType cft = cf.getCustomFieldType();

final MultipleSettableCustomFieldType mc = (MultipleSettableCustomFieldType) cft;

anyway .thanks very much .