[scriptrunner]add select option

[arno]

Hi all

   We want to implement the automatic addition of custom field values to the radio field option for subsequent data statistics. Our custom fields are text/date types. I looked at the Select List Conversions (https://docs.adaptavist.com/sr4js/6.51.0/features/behaviours/behaviours-examples/select-list-conversions#)

    The first one works fine, but I want to optimize it so that it returns custom field values, can you tell me if this is supported

[Sergei Troshin · Accepted solution]

Hi @arno again :)

Here is my code snippet:

import com.atlassian.jira.issue.Issue
import org.apache.commons.lang3.StringUtils
import com.atlassian.jira.issue.fields.CustomField
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.fields.config.FieldConfig
import com.atlassian.jira.issue.customfields.option.Options
import com.atlassian.jira.issue.customfields.manager.OptionsManager

// Consts
final String SOURCE_TEXT_FIELD_CF_ID = "customfield_10500"
final String TARGET_SELECT_LIST_CF_ID = "customfield_10400"

// Classes
final CustomFieldManager customFieldManager = ComponentAccessor.getComponent(CustomFieldManager.class)
final OptionsManager optionsManageer = ComponentAccessor.getComponent(OptionsManager.class)

Issue issue = issue //Issues.getByKey("SOFTWARE-25")

CustomField sourceTextField = customFieldManager.getCustomFieldObject(SOURCE_TEXT_FIELD_CF_ID)
CustomField targetSelectListField = customFieldManager.getCustomFieldObject(TARGET_SELECT_LIST_CF_ID)

String sourceTextFieldValue = issue.getCustomFieldValue(sourceTextField)
if (StringUtils.isEmpty(sourceTextFieldValue)) {
    log.warn("Source Text Field is Empty")
    return
}

FieldConfig targetSelectListFieldConfig = targetSelectListField.getRelevantConfig(issue)
if (Objects.isNull(targetSelectListFieldConfig)) {
    log.warn("Target Field doesn't have context for current issue")
    return
}

Options targetSelectListFieldOptions = optionsManageer.getOptions(targetSelectListFieldConfig)
if (targetSelectListFieldOptions.any { it.value.equals(sourceTextFieldValue) }) {
    log.warn("Current text value already persist in Select List")
    return
}

try {
    targetSelectListFieldOptions.addOption(null, sourceTextFieldValue)
} catch (Exception ex) {
    log.error(ex)

}

I placed this as Post-Function at the end of 'Create' transition:

Here is my usage:

At this step i am creating issue with text value = CustomOption #3 and as you can see in Select List only two options:

After creation my Post-Function executed and Select List was populated with another one option:

Hope this will be useful for you :)

---

Important! I've tested my code, but i'd recommend you test one more time on Test Enviroment :)

[arno]

Hi @Sergei Troshin 

   thank you for your help 

  I'm sorry for replying to you so late. I used your code and did some format conversion, the effect is great, this problem will be closed, thank you again for your help

[Sergei Troshin]

Hi @arno hope you're doing well!

Let's clarify your requirements.
Do you want to populate all unique values from text and date picker fields as options in a separate Radio Button field?
After that, do you want to retrieve the list of all options in the Radio Button field?

[arno]

Hi @Sergei Troshin 

  Thank you for your reply.

   Yes，the effect we want to achieve is that when a user fills in a certain custom field (text/date), the value of this custom field can be provided as an option for the user to select when closing the ticket.

[Sergei Troshin]

Hi @arno hope you're doing well!

Please, consider this script: Add a new option to a select list when an issue is created.

This script provides a basic example of how to populate a Select List with a value from a Text Field. Populating it with a Date Field value can be done in a similar way.

If you need any help with script modernization, feel free to ask—I’ll do my best to assist you.

---

Important! Pay attention to 12 code line:

def fieldConfig = companyField.getRelevantConfig(IssueContext.GLOBAL)

This line is responsible for adding a new Select List option in a context with a Global scope.

[arno]

Hi @Sergei Troshin 

   Please forgive me if I can only reply to you here

   Thank you for your reply,I do need your help, due to version differences, we can not directly use the field name method to obtain the field value, my current code is as follows, filed1 is an option field, filed2 is a text field, how should I optimize my code:

import com.atlassian.jira.component.ComponentAccessor

def customFieldManager = ComponentAccessor.customFieldManager

def optionsManager = ComponentAccessor.getOptionsManager()

def filed1 = customFieldManager.getCustomFieldObject('customfield_14304')

def filed2 = customFieldManager.getCustomFieldObject('customfield_14305')

def value = issue.getCustomFieldValue(filed2).toString()

[Sergei Troshin]

Hi @arno :)
Ok, give me some time during the day.

[arno]

OK ,look forward to your good news

[Sergei Troshin]

Hi @arno hope you're doing well!

Any news about provided solution?