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
fieldnameIDwith 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
| table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header | |
|---|---|
| Adobe Workfront package | Any |
| Adobe Workfront license |
Contributor or Request to modify a filter Standard or Plan to modify a report |
| Access level configurations |
Edit access to Reports, Dashboards, Calendars to modify a report Edit access to Filters, Views, Groupings to modify a filter |
| Object permissions | Manage permissions to a report |
For more detail about the information in this table, see Access requirements in Workfront documentation.
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, then Edit Text Mode.
-
Replace the
valuefieldline (valuefield=portfolio:ownerID) with the following line:valuefield=portfolio:owner:nameOr
Remove the text you find in the Edit 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=portfolioIn this particular example, the report will sort the report by the Portfolio Owner ID, as indicated by the
querysortline.note tip TIP To replace any field IDwith the fieldnameusing text mode, always replaceIDwith:namein thevaluefieldline. -
Click Done, then Save View.