Report of New issues not yet converted to a project, want to add column with assigned team, team members | Community
Skip to main content
ajdifonzo
ajdifonzo
Level 3
August 29, 2023
Solved

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

  • August 29, 2023
  • 1 reply
  • 614 views

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 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

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-collections-report.html?lang=en

 

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.

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
August 29, 2023

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-collections-report.html?lang=en

 

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.

ajdifonzo
ajdifonzoAuthor
Level 3
August 29, 2023

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

Terms & ConditionsAccessibility statement

Loading footer...