Skip to main content
Level 3
Jul 27, 2023 4:48 PM UTC
Solved

last update note Text

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.
VicSellers
VicSellersAccepted solution
Adobe Champion, Community Advisor, UG Leader
Jul 27, 2023 5:49 PM UTC

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

10 replies

VicSellers
Adobe Champion, Community Advisor, UG Leader
VicSellersAdobe Champion, Community Advisor, UG LeaderAccepted solution
Adobe Champion, Community Advisor, UG Leader
Jul 27, 2023 5:49 PM UTC

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
Translate
Kundanism
Level 10
Jul 28, 2023 8:46 AM UTC

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

Mvh

Translate
IanReAuthor
Level 3
Jul 28, 2023 5:54 AM UTC

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

Translate
New Member
Mar 5, 2025 5:57 PM UTC

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?

Translate