Copy Cascading Select value to Single Select field

Rose Cruz

The Cascading Select field type in JIRA is incompatible with the new Zendesk Integration for JIRA. For this reason we are considering a change back to a single select field. This would affect 183K issues. I've read that the data is different from field to field, and it sounds like its not possible to copy the values via "Built-in Script" from ScriptRunner. Aside from standard bulk-update or workflow post-functions, is there some other way we can programmatically update sets of issues based on the cascading select value, without registering in the issue's change log? 

Jonny Carter_3nm6du

So, updating an issue without affecting the issue history is not well supported by the API.

That said, for a one-off mass-update, you could write a script for the Script Console that did the update. You'd want to get the results of a JQL query, then edit each item in the list.

This fairly naive example demonstrates how you'd take a cascading list custom field value and set a corresponding select list to the value that matched only the first list in the cascading select. You could modify it a bit to find more complex options, depending on what options you have configured for your single select list.

import com.atlassian.jira.issue.search.SearchProvider
import com.atlassian.jira.jql.parser.JqlQueryParser
import com.atlassian.jira.web.bean.PagerFilter
import com.atlassian.jira.component.ComponentAccessor

def jqlQueryParser = ComponentAccessor.getComponent(JqlQueryParser)
def searchProvider = ComponentAccessor.getComponent(SearchProvider)
def issueManager = ComponentAccessor.getIssueManager()
def user = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()

// edit this query to suit
def query = jqlQueryParser.parseQuery("project = JRA and assignee = currentUser()")

def results = searchProvider.search(query, user, PagerFilter.getUnlimitedFilter())

log.debug("Total issues: ${results.total}")

def issueService = ComponentAccessor.getIssueService()
def customFieldManager = ComponentAccessor.getCustomFieldManager()

results.getIssues().each {documentIssue ->
    // if you need a mutable issue you can do:
    def issue = issueManager.getIssueObject(documentIssue.id)
    def cascade = customFieldManager.getCustomFieldObjectByName("CascadingSelect") //your cascading select here
    def singleSelect = customFieldManager.getCustomFieldObjectByName("SelectListA") //your new select list here
    def singleSelectConfig = singleSelect.getRelevantConfig(issue)
    
    def optionsManager = ComponentAccessor.getOptionsManager()
    def options = optionsManager.getOptions(singleSelectConfig)
    def cascadeValue = cascade.getValue(issue)?.collect{it.value}?.getAt(0)?.toString()
    def optionToGet = options.find {it.value.toString() == cascadeValue}


    def inputParameters = issueService.newIssueInputParameters()
    inputParameters.addCustomFieldValue(singleSelect.idAsLong, optionToGet.optionId.toString())
    def updateValidationResult = issueService.validateUpdate(user, issue.id, inputParameters)
    issueService.update(user, updateValidationResult)
}

If you need to reuse this a lot for some reason, you could wrap it up in a Canned Script.