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 the fieldname: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

Expand to view access requirements for the functionality in this article.

You must have the following access to perform the steps in this article:

table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header
Adobe Workfront plan Any
Adobe Workfront license*

New:

  • Contributor to modify a filter

  • Standard to modify a report

Current:

  • Request to modify a filter

  • 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 information, see Access requirements in Workfront documentation.

Example: add the Portfolio Owner Name column to a project view

  1. Go to a list of projects.

  2. From the View drop-down menu, click New View.

  3. 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.

  4. Click Switch to Text Mode, then Edit Text Mode.

  5. Replace the valuefield line (valuefield=portfolio:ownerID) with the following line:

    valuefield=portfolio:owner:name

    Or

    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=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 field name using text mode, always replace ID with :name in the valuefield line.
  6. Click Done, then Save View.

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43