Text Mode - ObjectID to ObjectName | Community
Skip to main content
Alexa_M_PSU
Alexa_M_PSU
Level 2
September 29, 2022
Question

Text Mode - ObjectID to ObjectName

  • September 29, 2022
  • 1 reply
  • 861 views

Is there a way in groupings, columns, filters, via text mode to change ObjectID to ObjectName? 

 

ie: PortfolioID to PortfolioName when Portfolio Name isn't one of the options to select, but Portfolio ID is an option? 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

M
maura-k
Level 3
September 29, 2022

This is something I do all the time in reports and I use text mode to change the column. I haven't tried to make these types of updates for the Grouping or Filters though. Here is an example for an Issue report where you want to pull the Portfolio name of the resolving project.

 

Original text mode for Resolve Project:Portfolio ID

 

valuefield=resolveProject:portfolioID
querysort=resolveProject:portfolioID
valueformat=HTML
displayname=
linkedname=resolveProject
namekey=view.relatedcolumn
namekeyargkey.0=resolveProject
namekeyargkey.1=portfolioID

 

Updated text mode (changes in bold)

valuefield=resolveProject:portfolio:name     <- Removed the "ID"
querysort=resolveProject:portfolio:name     <- Removed the "ID"
valueformat=HTML
displayname=
linkedname=resolveProject
namekey=view.relatedcolumn
namekeyargkey.0=resolveProject
namekeyargkey.1=portfolio     <- Removed the "ID"

namekeyargkey.2=name

    K
    KevinQu1
    Level 10
    October 5, 2022

    I just wish that Workfront:

     

    1. Was more consistent whether to default to ID or name (hint: name!).
    2. At least had a little toggle or UI element to switch from ID to Name so we didn't have to dive into Text Mode every single time.
    Terms & ConditionsAccessibility statement

    Loading footer...