Expand my Community achievements bar.

SOLVED

Portfolio Column in a task report

Avatar

Level 2

I am trying to get a portfolio column to show up in a task report. What am I doing wrong? I don't want to group by portfolio; just a column showing the portfolio associated with the project and task.

displayname=Product Segment
linkedname=lastConditionNote
namekey=view.relatedcolumn
namekeyargkey.0=lastConditionNote
namekeyargkey.1=portfolio:name
querysort=lastConditionNote:portfolio:name
textmode=true
valuefield=lastConditionNote:portfolio:name
valueformat=HTML

 

CarolCaruso_0-1732577045082.png

 

1 Accepted Solution

Avatar

Correct answer by
Level 9

Hi, @CarolCaruso. Based on the text mode you pasted, it appears your column is referencing the last condition note of the task first. You want to reference the task's project's portfolio. Thus 

valuefield=project:portfolio:name
  1. When adding a column, start typing in the search bar "project portfolio."
  2. You should have the option to select "Portfolio ID" under the Project grouping of fields.
  3. Switch to text mode and update the valuefield from "project:portfolioID" to "project:portfolio:name"

P.S. If you're not familiar with the API Explorer, check it out. This helps you figure out which report objects you can reference based on the report type.

View solution in original post

2 Replies

Avatar

Correct answer by
Level 9

Hi, @CarolCaruso. Based on the text mode you pasted, it appears your column is referencing the last condition note of the task first. You want to reference the task's project's portfolio. Thus 

valuefield=project:portfolio:name
  1. When adding a column, start typing in the search bar "project portfolio."
  2. You should have the option to select "Portfolio ID" under the Project grouping of fields.
  3. Switch to text mode and update the valuefield from "project:portfolioID" to "project:portfolio:name"

P.S. If you're not familiar with the API Explorer, check it out. This helps you figure out which report objects you can reference based on the report type.

Avatar

Level 2

Hi @Lyndsy-Denk - that did the trick! I started with that field but changed all instances of ID to :name.  Which is where I then started confusing myself.  I've taken a few webinars on API explorer with Workfront but I'm not fully confident with it yet.  I appreciate your help though and it solved my problem! Thank you!