Add last update to a task report | Adobe Higher Education
Skip to main content
Level 3
March 21, 2025
Respondido

Add last update to a task report

  • March 21, 2025
  • 1 resposta
  • 415 Visualizações

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. 

Melhor resposta por 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 Resposta

skyehansen
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community AdvisorResposta
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.