Assignee Full Name while using Structure JOIN#children{Assignee}

[Corey Hutchinson]

Using Structure with hierarchical data Initiative -> Epic 

Goal is to aggregate the list of Epic Assignees by Initiative.

• Data = initiatives 
• Extend with "Child Issues (Portfolio)" aka our Epics
• Create formula column with: JOIN#children{Assignee}

Data is correct and we have our comma separated list of epic owners by Initiative.  Issue is the names are the username i.e. DoeJoe, SmithB, whereas we want the full names John Doe, Bob Smith

Any converts or format we can apply to the formula column equation?

[Egor Tasa [ALM Works] · Accepted solution]

Hi Corey,

The issue here is that assignee field is returning html (icon + text). So you would have to parse HTML output.

For that, first click on assignee variable below formula and in a drop-down select Manual Specification this will switch output to html.

And to parse it, use the following formula:

JOIN#children{SUBSTRING(assignee, SEARCH("/>[^>]+</a>/", assignee), SEARCH("</a>", assignee)-1)}

Please, let me know if it helps.

Regards,
Egor Tasa

ALM Works 

[Egor Tasa [ALM Works]]

Just a clarification, Corey. 

I just realized, that I haven't expanded on Manual Specification piece. When you open Manual Specification, you will see:

{"id":"assignee","format":"text"}

 Change it to:

{"id":"assignee","format":"html"}

 Sorry for potential confusion.

Regards,
Egor Tasa

ALM Works

[Corey Hutchinson]

Worked Perfect Thank you !