Add last update to a task report | Community
Skip to main content
Level 3
March 21, 2025
Solved

Add last update to a task report

  • March 21, 2025
  • 1 reply
  • 384 views

Hello, I created a status task report and think it would be great to pull in the last update that was made.  I'm using text mode from the 2017 Reporting cookbook, but it isn't working correctly.  Furthermore, after I copy and paste it in text mode, the sequence of the code changes. 

Code from cookbook. 

displayname=Last Note
querysort=lastNote:entryDate
textmode=true
valueexpression=IF(LEN({lastNote}.{noteText})>140, CONCAT(SUBSTR({lastNote}.{noteText},0,139),"...(open
for more) -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate}), IF(LEN({lastNote}.{noteText})>0,
CONCAT({lastNote}.{noteText}," -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate})))
valueformat=HTML
width=250
usewidths=true

 

Code once pasted into WF. 

CONCAT({lastNote}.{noteText},"=-- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate})))
displayname=Last Note
for=more) -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate}), IF(LEN({lastNote}.{noteText})>0,
querysort=lastNote:entryDate
usewidths=true
valueexpression=IF(LEN({lastNote}.{noteText})>140, CONCAT(SUBSTR({lastNote}.{noteText},0,139),"...(open
valueformat=HTML
width=250

 

I'd appreciate any help you could provide.  Thank you. 

Best answer by skyehansen

everything between “valueexpression” and “valueformat” should be one long line. Instead, it looks as though you have somehow introduced several linebreaks into your code—probably as part of the copy/paste process. 

1 reply

skyehansen
Community Advisor
skyehansenCommunity AdvisorAccepted solution
March 22, 2025

everything between “valueexpression” and “valueformat” should be one long line. Instead, it looks as though you have somehow introduced several linebreaks into your code—probably as part of the copy/paste process.