Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!
SOLVED

Report of New issues not yet converted to a project, want to add column with assigned team, team members

Avatar

Level 3

Hi All, 

 

I have an Issue report that shows all new issues not yet converted to a project.  I already have the assignment team column in the report, but I would like to have a column with the list of people that belong to the assigned team.  When I use the column Team:Team Members I get nothing.  

 

Thanks in advance 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

hi, you're on the right track but you need to consider that your syntax might be a little off (I can't tell what your actual column consists of) and you are trying to reference a collection of users (i.e. more than one). For the latter you would be best served by reading up on collections here:

 

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/reference-collec...

 

Consider the following sample text mode:

 

displayname=Team members
listdelimiter=<p>
listmethod=nested(team.teamMembers).lists
textmode=true
type=iterate
valueexpression=CONCAT({user}.{name})
valueformat=HTML

 

This is a sample only, but you will clearly see your team "team members" call being used in the correct syntax. I think the specific code above would call the primary team assigned, and list all the team members regardless of whether they are active or deactivated. But it's a start just to show you what can be done.

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

hi, you're on the right track but you need to consider that your syntax might be a little off (I can't tell what your actual column consists of) and you are trying to reference a collection of users (i.e. more than one). For the latter you would be best served by reading up on collections here:

 

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/reference-collec...

 

Consider the following sample text mode:

 

displayname=Team members
listdelimiter=<p>
listmethod=nested(team.teamMembers).lists
textmode=true
type=iterate
valueexpression=CONCAT({user}.{name})
valueformat=HTML

 

This is a sample only, but you will clearly see your team "team members" call being used in the correct syntax. I think the specific code above would call the primary team assigned, and list all the team members regardless of whether they are active or deactivated. But it's a start just to show you what can be done.

Avatar

Level 3

Thank you Sky.  I was on the right road, just the wrong lane.