You can display in a view objects that are not included in the standard mode interface. You can do this only by referencing them via text mode.
You can determine which fields can be included in a view in either of the following ways:
Use the API Explorer to discover other objects that can be referenced via text mode.
Not all the fields documented in the API Explorer are valid fields for text mode. Some fields are only reportable through the API.
Find the object 's ID field in a column. Most objects that have a field ID also have a corresponding column or field name which may not be accessible through the standard mode interface.
You can use text mode to include in a view the column or field name instead of the ID by replacing the
fieldnameID with the
For example, in the standard mode interface, the Portfolio Owner ID field is available for a project view, but the Portfolio Owner Name field is not. You can use text mode to display the Portfolio Owner Name in the column of a view.
You must have the following access to perform the steps in this article:
|Adobe Workfront plan*||
|Adobe Workfront license*||
|Access level configurations*||
Edit access to Reports, Dashboards, Calendars
Edit access to Filters, Views, Groupings
Note: If you still don't have access, ask your Workfront administrator if they set additional restrictions in your access level. For information on how a Workfront administrator can modify your access level, see Create or modify custom access levels.
Manage permissions to a report
For information on requesting additional access, see Request access to objects .
*To find out what plan, license type, or access you have, contact your Workfront administrator.
Go to a list of projects.
From the View drop-down menu, click New View.
Click Add Column then start typing “Portfolio Owner ID” in the Show in this column field, then select it when it displays in the list.
Click Switch to Text Mode.
Hover over the text mode area, and click Click to edit text.
valuefield line (
valuefield=portfolio:ownerID) with the following line:
Remove the text you find in the Text Mode box, and replace it with the following code:
valuefield=portfolio:owner:name querysort=portfolio:ownerID valueformat=HTML displayname=Portfolio Owner Name linkedname=portfolio
In this particular example, the report will sort the report by the Portfolio Owner ID, as indicated by the
To replace any field
ID with the field
name using text mode, always replace
:name in the
Click Save, then Save View.