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
skyehansenCommunity AdvisorAccepted 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...