lastnote: note text | Community
Skip to main content
Level 2
May 7, 2026
Question

lastnote: note text

  • May 7, 2026
  • 3 replies
  • 23 views

Hello,

 

I know i can bring this in a task report, but Is there anyway I can bring in lastnote: note text in a note report?

    3 replies

    ninoskuflic
    Level 4
    May 7, 2026

    If I understood correctly, you want to make a report of all the notes and then on that report show lastNote? You would need to pick an object first - a note cannot have a note. E.g. last note from project. 

     

    Is that what you are trying to achieve or something else? 😃

    If this solved your issue, please mark it as solved so others can find the solution faster.
    skyehansen
    Community Advisor and Adobe Champion
    May 7, 2026

    yes, I agree with Nino.

     

    The fact that a note is the Last Note, is information that is kept on the object itself. A project would hold information on what the last note on that project, is (edited to add that the information stored on the project is the lastNoteID -- so also nothing super useful from a reporting standpoint). The note itself would not hold this information. So the only way you would be able to approach creating a report with lastnote information MIGHT be to experiment on whether there’s an exists statement that would filter for ONLY notes that are last notes on a specific type of object (like, for example, “there exists a project where the lastnoteID = the note’s ID”). But there isn’t really a way to indicate in a view that this particular note is a “last note”

    SejalPaAuthor
    Level 2
    May 7, 2026

    I have a Note report that queries anything from a particular # value. In the column of this report I would like see the last note posted in the task to help attain the latest status of the task as it would noted in the comment if the issue with the # was resolved or pending. The note report does not allow for lastnote: note text as the DB does not recongize that field, but that field works on a task or project report. So, I wanted to see if there might be workaround to have the contents appear in a note report.

    skyehansen
    Community Advisor and Adobe Champion
    May 7, 2026

    OK, so in other words, if your note report has a note “Test #TEST”, then IF this note is on a task, the following text mode would bring in the latest note on that task.

     

    This means that if the latest note is the above note, it will duplicate that. And if there’s a newer note, like “Updated 2nd note” it will bring this in, instead.

     

    linkedname=task
    namekey=view.relatedcolumn
    namekeyargkey.0=task
    namekeyargkey.1=lastNote:noteText
    querysort=task:lastNote:noteText
    valuefield=task:lastNote:noteText
    valueformat=HTML

     

    SejalPaAuthor
    Level 2
    May 7, 2026

    Yes!! You’re amazing! This worked and brought in the last comment posted in the task! Thank you so much!

     

    I have one additional query. The report also has a column for Owner » Name which now shows who entered in the comment with the #, is there a way that can update based on who commented last in the task 

    skyehansen
    Community Advisor and Adobe Champion
    May 7, 2026

    yes, start converting some of your columns to textmode so you can follow along. Compare the current noteText column with the new one you brought in and you will probably notice they’re pretty similar but the new column has task:lastNote:___ prepending the front of certain lines.

    You would do the same thing with your owner column -- just make a copy of it, flip it to text mode, and start prepending the same “task:lastNote:” prefix to your lines. Experiment with other fields. Have fun.