last update note Text | Community
Skip to main content
I
IanRe
New Participant
July 27, 2023
Solved

last update note Text

  • July 27, 2023
  • 2 replies
  • 2150 views

Hi community, I have a requirement to see last updated Note text in a report we have.

I can easily do this in a request/issue report and a project report.

But we have a task report (Used because we have a Go-Live task on our projects and a subsequent 5 day check task prior to the project auto closing on last task completion) I cant seem to find the option for 'Last note text' so in the report i can see the last update on the Project  all the ones available show as blank.

If i switch to a project report to allow me to have i believe i cant filter a project report, based on task containing Go-Live..is not complete/complete

 

Best answer by VicSellers

Hi @ianre - The text mode below will pull the last note from the project on a task report. Hope this helps!

 

displayname=Last Note linkedname=lastNote namekey=view.relatedcolumn namekeyargkey.0=lastNote namekeyargkey.1=noteText querysort=lastNote:noteText textmode=true valuefield=project:lastNote:noteText valueformat=HTML

2 replies

I
IanReAuthor
New Participant
July 28, 2023

Amazing thank you VLinn, i had tried editing text mode but it seems i still have lots to learn about text mode structure

O
OmPr
New Participant
March 5, 2025

How can we show only the first 200 characters of last update notes in report column views instead of showing the whole notes update paragraphs?

VicSellers
VicSellersAccepted solution
New Participant
July 27, 2023

Hi @ianre - The text mode below will pull the last note from the project on a task report. Hope this helps!

 

displayname=Last Note linkedname=lastNote namekey=view.relatedcolumn namekeyargkey.0=lastNote namekeyargkey.1=noteText querysort=lastNote:noteText textmode=true valuefield=project:lastNote:noteText valueformat=HTML
    Kundanism
    Kundanism
    New Participant
    July 28, 2023

    Thanks @vicsellers , This is a great tip, and the same text code works for Assignment report too.

    Mvh

      Terms & ConditionsAccessibility statement

      Loading footer...