Expand my Community achievements bar.

Add last update to a task report

Avatar

Level 3

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. 

1 Reply

Avatar

Community Advisor

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.