last update note Text | Community
Skip to main content
I
IanRe
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

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
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

VicSellers
Community Advisor
VicSellersCommunity AdvisorAccepted solution
Community Advisor
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
    July 28, 2023

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

    Mvh

      I
      IanReAuthor
      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
      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?

      Terms & ConditionsAccessibility statement

      Loading footer...