Report on all users assigned in a project? | Community
Skip to main content
Lyndsy-Denk
Community Advisor
Community Advisor
August 9, 2021
Solved

Report on all users assigned in a project?

  • August 9, 2021
  • 1 reply
  • 759 views

I'm trying to build a project report that includes a column listing all project assignments. I've yet to find the right field to pull. Is it possible in a more creative way?

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 svetlanasilina

Hi Lyndsy! If I'm reading your question correctly, you'd like to run a project report and have a column that lists the project team for each project. This would add all users that are associated with a project and listed under the People area of the project. Is that correct?

You could follow these steps to do that using text mode:

  1. Create a Project report with the required filters, views and groupings
  2. While adding the report, add a column to the View, select the column by clicking on the column header and switch to text mode
  3. Paste the following code into the text mode and Save the report

description=Team Users

displayname=Project Team

listdelimiter=<div>

listmethod=nested(projectUsers).lists

textmode=true

type=iterate

valueexpression=CONCAT("* ",{user}.{name})

valueformat=HTML

NOTE: You can remove the * that shows up as a bullet for each name by removing the "* ", part of the code.

I hope that this helps to resolve your obstacle!

1 reply

svetlanasilinaAdobe EmployeeAccepted solution
Adobe Employee
August 9, 2021

Hi Lyndsy! If I'm reading your question correctly, you'd like to run a project report and have a column that lists the project team for each project. This would add all users that are associated with a project and listed under the People area of the project. Is that correct?

You could follow these steps to do that using text mode:

  1. Create a Project report with the required filters, views and groupings
  2. While adding the report, add a column to the View, select the column by clicking on the column header and switch to text mode
  3. Paste the following code into the text mode and Save the report

description=Team Users

displayname=Project Team

listdelimiter=<div>

listmethod=nested(projectUsers).lists

textmode=true

type=iterate

valueexpression=CONCAT("* ",{user}.{name})

valueformat=HTML

NOTE: You can remove the * that shows up as a bullet for each name by removing the "* ", part of the code.

I hope that this helps to resolve your obstacle!

Lyndsy-Denk
Community Advisor
Community Advisor
August 9, 2021

Thank you! That worked perfectly.