Overview
In many types of Reports, due to objects' second-level hierarchy relationship, "Name" value is not displayed. Instead, Workfront shows only the "ID" of the object. When trying to get the "Name" to display in the view, a Text Mode edit is needed.
Details
- Go to the Report
- Add the Column with "ID" value
- Switch to Text Mode>Click to edit text
- Replace all ID values with ":name" value > Save
- Replace valueformat=**** with valueformat=HTML
- Optional: set a display name for your column in "displayname=" line
- See an example below:
Original:
valuefield=owner:managerID
querysort=owner:managerID
valueformat=HTML
displayname=
linkedname=owner
namekey=view.relatedcolumn
namekeyargkey.0=owner
namekeyargkey.1=managerID
Replaced:
valuefield=owner:manager:name
querysort=owner:manager:name
valueformat=HTML
displayname= Owner Manager Name
linkedname=owner
namekey=view.relatedcolumn
namekeyargkey.0=owner
namekeyargkey.1=manager:name
*Click to enlarge the image
Note:
This article was written in reference to Views in Workfront, not necessarily Groupings. Using these same tips in regards to groupings will usually work, but with one main caveat. If a grouping is ever modified in text mode, the modification will break the chart views.
This will still work for default Groupings via textmode modification but without Charts applied to the Report. The change is NOT possible for Matrix type Reports.
Thank you for taking the time to provide feedback. We appreciate and value your contribution to our site. Feedback provided here is regularly reviewed by our Product Documentation team. Please ensure your comments are specific to improving this help article. Any questions or requests outside this help article content should be directed to our Community User Forum or by submitting a ticket to customer support.
Can you switch the ID value to a name when dealing with Matrix Groupings? How is this done? that would be great to include here.