What causes a Select custom field to freeze when displaying it's options?

[Cheikh Sadibou Charles NDIAYE]

I have a Select custom field with around 5000 options. When i display the options, Jira freezes. So i can't use the interface to update the options. 

Do you have any solutions for this??

[MattD]

Yes, it is annoying that select fields don't scale past a few thousand options. I have had some success in the past using a single line text field and ScriptRunner to call a REST API to retrieve the option values. So you type the first few characters of the option and are presented with a list of choices. Worked pretty well with about 10,000 options for us.

[MattD]

https://mraddon.blog/2019/09/26/how-to-create-a-jira-custom-field-with-options-from-an-external-rest-api/ is the idea I'm referring to

[Layssa Souza]

@Cheikh Sadibou Charles NDIAYE 

Do you have any plugins, such as script runner or Elements Connect?

Maybe changing the way this field is presented would be a good idea.

Jira doesn't handle fields with a lot of options so well, so perhaps having a field that allows you to use the "search" option within it would be a more acceptable path.

Maybe change, change the "Select" field to a search field (Dynamic Search Field). Therefore, values ​​are only loaded as the user types.

I hope this can help you in some way

Best regards.

[Dick]

Hi @Cheikh Sadibou Charles NDIAYE 

The obvious choice would be to shorten the list of options as it is also very inconvenient to your users to scroll through such a long list on a normal computer screen. 

Best tip would be to break things up into logical categories and have a short dropdown per category. How many categories would depend on the data structure behind the options (what these describe). Be kind to your users :)

Kind regards

Dick

[Cheikh Sadibou Charles NDIAYE]

Hi @Dick 

The users don't directly interact with the custom field. We have a seperate web portal(different from JSM's) with cascading fields so the values displayed for our custom field reduces a lot(around 10) depending on the previously selected options. The thing is since our web portal is integrated to jira we often need to update some fields on jira also so that both apps can communicate seemlessly.

[Dick]

Would it be beneficial to give each of the cascading fields from your portal a separate (custom)Jira  field?

Kind regards,

Dick

[Cheikh Sadibou Charles NDIAYE]

Yes that's exactly what we did. On our portal everything is working fine, our issue is on jsm when we try to update the values on our custom fields. I will try to check the logs to see why the app freezes.