I have researched here and have not come up with what I was looking for.
I have a report that shows, by Project, all tasks that have an update made in the last seven days. The only piece of data I'm
unable to get is who entered the note. Any help would be appreciated.
I tried this, but it delivered a blank field.
[code language=”text” autolinks=”false”]
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
[/code]
This report is very handy when on a conference call with the customer and I need a quick reference on the status/work done on the project tasks.
Thanks,
Mary
Solved! Go to Solution.
Ahh ok, if you are using a note report you could just add the the owner >> name attribute to your view. This will be available natively in the report builder and you wont need any text mode for this.
If however, you are wanting to trim the note text down to less than 140 characters and include the date and note owner in the same field, this code would do it:
displayname=Note with owner and date namekey=latest update textmode=true valueexpression=IF(LEN({noteText})>140,CONCAT(SUBSTR({noteText},0,139),"…(open for more) — ",{owner}.{name}," on ",{entryDate}),IF(LEN({noteText})>0,CONCAT({noteText}," — ",{owner}.{name}," on ",{entryDate}))) valueformat=HTML
Views
Replies
Total Likes
Hi Mary,
The textmode used is sound, but it looks like when it's been copied from an external source, some of the formatting / special characters have carried over + some additional lines of code which aren't needed and Workfront doesn't like it. Try the following code instead:
displayname=last 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
Best Regards,
Rich.
Views
Replies
Total Likes
Thank you, Richard. That didn't work the column is still blank.
Views
Replies
Total Likes
That's strange, the code works perfectly in my instance. Are you using a task report?
Views
Replies
Total Likes
No, I'm using a Notes report. If I use the Task option I can only pick up the last note, I want to see all notes posted to a task for the last 7 days. Do you know of a way to get all the notes using the TASK report?
Views
Replies
Total Likes
Ahh ok, if you are using a note report you could just add the the owner >> name attribute to your view. This will be available natively in the report builder and you wont need any text mode for this.
If however, you are wanting to trim the note text down to less than 140 characters and include the date and note owner in the same field, this code would do it:
displayname=Note with owner and date namekey=latest update textmode=true valueexpression=IF(LEN({noteText})>140,CONCAT(SUBSTR({noteText},0,139),"…(open for more) — ",{owner}.{name}," on ",{entryDate}),IF(LEN({noteText})>0,CONCAT({noteText}," — ",{owner}.{name}," on ",{entryDate}))) valueformat=HTML
Views
Replies
Total Likes
Thanks so much for your time on this. I will have to ask our Admin if they can add that attribute.
Views
Replies
Total Likes
Richard, I got the report working. Thanks so much.
Views
Replies
Total Likes
Awesome Mary, glad I could help.
If my advice resolved your problem, please mark it as an accepted solution so that other's know how to overcome the same problem in the future.
Best Regards,
Rich.
Views
Replies
Total Likes
Is it possible to display all the comments via Note Report not just the last comment?
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies