-
Type:
Suggestion
-
Resolution: Unresolved
-
Component/s: Visual SQL Step - Transformation Step
-
None
User Problem
I am concatenating a column of issue keys that have been turned into a hyperlink. The issue's hyperlinks are a link to the issue directly within Jira. When using the concatenate option in a Group & aggregate step the concatenated hyperlinked issues will only display the first issue key despite including all link values in the hyperlink. This behavior also seems to happen for hyperlinks that are concatenated in a SQL query as well. For example if I have two issues EX-1 and EX-2 that I concatenated based on a shared status, the following information would be displayed in the chart:
Actual concatenated value in the column: EX-1
Hyperlink value: [EX-1](issue URL), [EX-2](issue URL)
Suggested Solutions
Allow the concatenation within the Group & aggregate step, or SQL mode query, to respect the hyperlink values if multiple hyperlinks are being concatenated. Ideally, the concatenated string of the above example would show 'EX-1, EX-2' with the correct hyperlink to each issue.
Current Workarounds
No workarounds are currently known.