Question

How to display Last Note/Status Update added by an users in a report

Forum|Forum|7 years ago
March 13, 2018
3 replies
936 views

Hello, I am new to the community and did research without success to answer the question below: I can't figure out how to display the last task status update in a report regardless who made the updates. Currently, only status updates added by the task owner display: I want to display the last update for each remaining taks, whether the text updates made by the tasks owner or any other team member. I am able to display on the Project level (Customized view) but can't in a report (to display in a dashboard). Any advice? Thanks in advance! Isabel

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

N

NRYNR

Level 10

This should work in either a task, issue or project report. Latest Update Purpose: Show the latest update, who provided it and when. Only shows the first 139 chars and a "more" if there is more to be read.

displayname=Latest Update

namekey=latest update

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