How do you find issues when custom field changed in ScriptRunner Console?

Diana Gorv

Since you can't use JQL operator "was" or "changed" for custom field, I'm resorting to ScriptRunner Console.

I have issue types Bug and Story that both uses a radio button custom field (let's say with options 1,2,3,4 etc). When a Bug or Story is created, it might have "Option 1" selected. But later on, the radio button custom field was changed to "Option 2". 

How do I pull issues that were once "Option 1" as well as all issues that are still "Option 1" on the Console? 

I have looked up these references, but we don't have easybi and would like not to resort to purchasing apps. https://community.atlassian.com/t5/Jira-questions/How-to-get-historical-values-from-custom-field-with-scriptrunner/qaq-p/1879270 

Tim Chen

Using issue.getCustomFieldValue for radio button IS Option 1

Using changeHistoryManager.getChangeItemsForField to retrieve updated histories of radio button in specific issue. 

def radio_field = ComponentAccessor.customFieldManager.getCustomFieldObjectsByName(RADIO_FIELD_NAME)[0]

// radio button IS Option 1
Closure<Boolean> is_option_1 = {Issue i ->
   i.getCustomFieldValue(radio_field).value == 'Option 1'
}

// radio button WAS Option 1
Closure<Boolean> was_option_1 = {Issue i ->
  // retrieve histories of specific customfield in issue
  def radio_field_histories = ComponentAccessor.changeHistoryManager.getChangeItemsForField(
    i, radio_field.name
  )

  // histories were once changed from Option 1
  radio_field_histories.any{ChangeItemBean changed_item -> 
    changed_item.fromString == 'Option 1'
  }
}

// issue = looped Bug & Story issue
return is_option_1(issue) ?: was_option_1(issue)