How to convert lastUpdateID to text display in textmode | Community
Skip to main content
A
Annie_972
May 8, 2023
Solved

How to convert lastUpdateID to text display in textmode

  • May 8, 2023
  • 3 replies
  • 1085 views

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?

Best answer by Madalyn_Destafney

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

3 replies

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
May 8, 2023

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

 

e.g. lastUpdatedByID turns into lastUpdatedBy:name

    Madalyn_Destafney
    Community Advisor
    Madalyn_DestafneyCommunity Advisor
    Community Advisor
    May 9, 2023

    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.

    If this helped you, please mark correct to help others : )
      A
      Annie_972Author
      May 9, 2023

      I got it! 

       

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

        Madalyn_Destafney
        Community Advisor
        Madalyn_DestafneyCommunity AdvisorAccepted solution
        Community Advisor
        May 9, 2023

        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
        May 9, 2023

        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

        Terms & ConditionsAccessibility statement

        Loading footer...