How to convert lastUpdateID to text display in textmode

[Annie_972]

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?

[skyehansen]

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

e.g. lastUpdatedByID turns into lastUpdatedBy:name

[Madalyn_Destafney]

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.

[Annie_972]

I got it! 

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

[Madalyn_Destafney · Accepted solution]

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

[Annie_972]

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