Text Mode - Task Report - Latest update by task

[MegSVT]

I'm wondering if anyone has a text mode column for the last update on a task, however, the text mode that I have created shows the last update for the entire project on the report, and I'm just looking to see a single update on an individual task. Can anyone help me out here?

displayname=Latest Update
namekey=latest update
shortview=true
valueexpression=CONCAT({project}.{lastNote}.{noteText}," -- ",{project}.{lastNote}.{owner}.{name}," on ",{project}.{lastNote}.{entryDate})
valueformat=HTML

[Alex_Di · Accepted solution]

Hi MegSVT, 

Since you are already on a task report this should work.  You were getting the Project information by having {project} in your expression. 

displayname=Latest Update
namekey=latest update
shortview=true
valueexpression=CONCAT({lastNote}.{noteText}," -- ",{lastNote}.{owner}.{name}," on ",{lastNote}.{entryDate})
valueformat=HTML

Hope this helps. 

[MegSVT]

Good catch! Thank you, this worked!