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!
@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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Great to hear that!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.