Dropdown showing every combo of a custom field as an option to select

[Yvette Nash]

I have created a dropdown control based off a custom field. This custom field can have multiple values when being set on our jira issues. This is causing the dropdown options to be every combination used. How do I make the dropdown only show the individual values? Example, I only want the dropdown to show A, B, C and not [A], [A,B], [B,C], etc 

Thank you in advance!

[Inder Singh · Accepted solution]

@Yvette Nash : Can you try the following SQL query in the Control edior (you would need to replace the custom field key with the one you are using):

-----

with tbl1 as
(
   SELECT EXPLODE(SPLIT(REPLACE(REPLACE(a.value, "[", ""), "]", ""), ', ')) AS Value
   FROM jira_issue_field AS a
   WHERE (a.field_key = 'customfield_12345')
   AND a.value IS NOT NULL
   GROUP BY Value
   ORDER BY Value ASC
)

select * from tbl1
GROUP BY Value

---------

Let us know if this works.

Thanks!

[Yvette Nash]

It worked beautifully! Thank you so much Inder!

[Inder Singh]

Great to hear that!