View: display objects that are not included in the standard interface
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 thefieldname:name
.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.
Access requirements
You must have the following access to perform the steps in this article:
*To find out what plan, license type, or access you have, contact your Workfront administrator.
Example: add the Portfolio Owner Name column to a project view
-
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.
-
Replace the
valuefield
line (valuefield=portfolio:ownerID
) with the following line:code language-none valuefield=portfolio:owner:name
Or
Remove the text you find in the Text Mode box, and replace it with the following code:
code language-none 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
querysort
line.note tip TIP To replace any field ID
with the fieldname
using text mode, always replaceID
with:name
in thevaluefield
line. -
Click Save, then Save View.