How do I insert new Custom Field options based on another single line custom field value.?

Stephen Higgins_i56eig

I am trying to take an incoming single line custom field value and insert it into several other single choice select list custom field values based on conditions. Any help would be appreciated. 

• Incoming Custom Field Names and Options
  • Vendor Request Type
    • Add New Vendor
    • Update Existing Vendor
    • Remove/Archive Vendor
  • Vendor Type
    • Payroll
    • HRIS
    • COBRA
    • Direct Bill
  • Vendor Name - Actual 
    • Single Text Field
• Outgoing Custom Field Lists to Update
  • Vendor Name
  • Payroll Vendor/s
  • HRIS Provider/s
  • Prior Administrator
  • COBRA Administrator
  • Direct Bill Administrator

Logic Being Requested:

• If Vendor Request Type = Add New Vendor 
  • If Vendor Name - Actual NOT IN Vendor Name
    • Add Vendor Name - Actual to Vendor Name
      • Alpha Sort List and Save
  • If Vendor Type = Payroll AND Vendor Name - Actual NOT IN Payroll Vendor/s
    • Add Vendor Name - Actual to Payroll Vendor/s
      • Alpha Sort List and Save
  • If Vendor Type = HRIS AND Vendor Name - Actual NOT IN HRIS Provider/s
    
    • Add Vendor Name - Actual to HRIS Provider/s
      • Alpha Sort List and Save
  • If Vendor Type = HRIS AND Vendor Name - Actual NOT IN Prior Administrator
    
    • Add Vendor Name - Actual to Prior Administrator
      • Alpha Sort List and Save
  • If Vendor Type = COBRA AND Vendor Name - Actual NOT IN COBRA Administrator 
    • Add Vendor Name - Actual to COBRA Administrator
      • Alpha Sort List and Save
  • If Vendor Type = Direct Bill AND Vendor Name - Actual NOT IN Direct Bill Administrator 
    • Add Vendor Name - Actual to Direct Bill Administrator
      • Alpha Sort List and Save

PD Sheehan

Let me see if I understand... you want to have a JSM form to allow user to submit updates to some Custom Field options.

You probably want to run this from a scriptrunner postfunction.

If so, something like this might work:

import com.atlassian.jira.issue.customfields.option.LazyLoadedOption
import com.atlassian.jira.component.ComponentAccessor
import com.onresolve.scriptrunner.runner.customisers.WithPlugin
import com.onresolve.scriptrunner.runner.customisers.PluginModule
import com.atlassian.servicedesk.api.requesttype.RequestTypeService
import com.atlassian.servicedesk.api.ServiceDeskManager
@WithPlugin("com.atlassian.servicedesk")
@PluginModule RequestTypeService requestTypeService
@PluginModule ServiceDeskManager serviceDeskManager

def cfm = ComponentAccessor.customFieldManager
def om = ComponentAccessor.optionsManager

//this map here is your critical logic ... 
//it maps the values selected in the Vendor Type field with each Single Select that must be updated
//you could easily add new option/fields if you needed to
def vendorTypeFieldMap = [
   'Payroll':     ['Vendor Name','Payroll Vendor/s',''],
   'HRIS':        ['Vendor Name','HRIS Provider/s','Prior Administrator'],
   'COBRA':       ['Vendor Name','COBRA Administrator'],
   'Direct Bill': ['Vendor Name','Direct Bill Administrator']
]

//custom fields objects that we'll use
def requestTypeCf = cfm.getCustomFieldObjectsByName('Customer Request Type')[0] 
def vendorTypeCf = cfm.getCustomFieldObjectsByName('Vendor Type')[0]
def vendorNameCf = cfm.getCustomFieldObjectsByName('Vendor Name - Actual')[0]

//raw values from those custom fields in the correct type
def requestTypeKey = issue.getCustomFieldValue(requestTypeCf) as String
def newVendorType = issue.getCustomFieldValue(vendorTypeCf) as LazyLoadedOption
def newVendorName = issue.getCustomFieldValue(vendorNameCf) as String

//the Customer Request Type custom field returns the Request Type key which is GUID number
//first we need the service desk object
def serviceDesk = serviceDeskManager.getServiceDeskForProject(issue.projectObject)

//then we build a requestType query
def queryBuilder = requestTypeService.newQueryBuilder()
queryBuilder.requestOverrideSecurity(true)
queryBuilder.serviceDesk(serviceDesk.id)

//fetch all the request types and filter for the one that match the key
def requestType = requestTypeService.getRequestTypes(null, queryBuilder.build()).find{requestTypeKey.contains(it.properties.key as String)}

//the main logic starts here
if(requestType.name == 'Add New Vendor'){
   //find the map item that matches the selection and loop through each fieldname to update
   vendorTypeFieldMap[newVendorType.value].each{targetFieldName ->
      def targetField = cfm.getCustomFieldObjectsByName(targetFieldName)[0]
      def config = targetField.getRelevantConfig(issue)
      def options = om.getOptions(config)
      if(!options.any{it.value == newVendorName}){
         om.createOption(config, null, 0, newVendorName)
         //reload the options including the new one
         options = om.getOptions(config)
         //sort them and update the sequence
         options.sort{it.value}.eachWithIndex{opt, i-> opt.sequence = i }
         //store the new sequence
         om.updateOptions(options)
      }
   } 
}