lastnote: note text

Forum|Forum|22 days ago
May 7, 2026
5 replies
89 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?

Best answer by skyehansen

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

ninoskuflic

Level 5

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

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”

S

SejalPaAuthor

Level 2

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

Accepted solution

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

S

SejalPaAuthor

Level 2

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

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.

S

SejalPaAuthor

Level 2

Thank you so much!!!

S

SejalPaAuthor

Level 2

Hi @skyehansen,

Reaching out again on the same report in case you might be able to help. I have this setup, but stakeholders have asked to me track another label in the same report. I have added an OR filter in the report, which is working as expected. I wanted to ask how I can have both labels show in the note text column in the report itself.

Thank you!

skyehansen

I’m not sure what you’re asking? If you have the filter shouldn’t both the labels have pulled in? Can you post a mockup of what you were expecting please?

S

SejalPaAuthor

Level 2

Sure, let me know if this helps.

Both are not getting capured in the note text column. 1 task could have be tagged with #label1test and then later #label2test. Currently only label1test is showing up in the note text column, not both.

for example