How to convert lastUpdateID to text display in textmode

5 replies
1092 views
Translate

Hello, I am trying to build an issue report that displays the last update. However, lastUpdateID displays a string of text (e.g.7wlsjdijiwijfldjfoy61892). How do I modify it in text mode to display the actual text?

Workfront

Madalyn_DestafneyAccepted solution

New Participant

Great, that's it! Please mark my answer correct to help others who may run into same question : )

If this helped you, please mark correct to help others : )

A

Annie_972Author

New Participant

I am using lastNoteID but I want to convert it to text. Here is my text mode:

displayname=
linkedname=direct
namekey=lastNoteID
querysort=lastNoteID
textmode=true
valuefield=lastNoteID
valueformat=text

Translate

Madalyn_Destafney

New Participant

Hi, if you're looking to pull the last update (comment in Updates feed), you'll want to pull 'Last Note > Note Text' into the report.

Translate

If this helped you, please mark correct to help others : )

A

Annie_972Author

New Participant

I got it!

valuefield=lastNote:noteText
linkedname=direct
valueformat=text
displayname=Last Note
namekey=lastNote:noteText
textmode=true
querysort=lastNote:noteText

Translate

Madalyn_DestafneyAccepted solution

New Participant

Great, that's it! Please mark my answer correct to help others who may run into same question : )

Translate

If this helped you, please mark correct to help others : )

skyehansen

Level 4

just take off every occurrence of "ID" and replace it with ":name"

e.g. lastUpdatedByID turns into lastUpdatedBy:name

Translate

Sign up

Login with SSO

Login to the community

Login with SSO