How can I add the portfolio and program name to my document report? | Community
Skip to main content
jessicaf4515285
January 6, 2021
Solved

How can I add the portfolio and program name to my document report?

  • January 6, 2021
  • 1 reply
  • 794 views

I've created a document report and added columns for Program Name and Portfolio Name which are available in the list of options, but the data is not populating. I've scoured the help articles but I only see the extensive training webinars for advanced reporting. While I am eager to review those webinars, we would like to get this report created quickly.

Does anyone have a solution? Thanks!

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 imgrund

Hi - yeah, documents are tricky because they can be on multiple object types. My guess is you picked a column that would appear if the document was at the portfolio or program level.

What level do you usually have documents? Like for us, it is at the project level so I use

valuefield=project:portfolio:name

valuefield=project:program:name

If you have them at the task level, you'll want: valuefield=task:project:portfolio:name

If you have them at the issue level, you'll want: valuefield=opTask:project:portfolio:name

Hope that helps.

1 reply

imgrund
Adobe Employee
imgrundAdobe EmployeeAccepted solution
Adobe Employee
January 6, 2021

Hi - yeah, documents are tricky because they can be on multiple object types. My guess is you picked a column that would appear if the document was at the portfolio or program level.

What level do you usually have documents? Like for us, it is at the project level so I use

valuefield=project:portfolio:name

valuefield=project:program:name

If you have them at the task level, you'll want: valuefield=task:project:portfolio:name

If you have them at the issue level, you'll want: valuefield=opTask:project:portfolio:name

Hope that helps.

jessicaf4515285
January 7, 2021

Hi Anthony, Thank you for your prompt response!

We host documents at the project level so that could be the issue with this report.

Your solution worked! Thank you so much for your help!