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.