Solved! Go to Solution.
Views
Replies
Total Likes
I created a report for these types of updates, using a Note report and adding this text mode in a column:
name=Update Information
textmode=true
valueexpression=IF(!ISBLANK({noteText}),{noteText},CONCAT("SYSTEM UPDATE: ",{auditText}))
valueformat=HTML
Views
Replies
Total Likes
New Project Report
Add column
Project >> Status Update
I suspect a similar function would work for Tasks
Views
Replies
Total Likes
I want the last system update though, the bold item without my photo by it.
Views
Replies
Total Likes
If you want to get really fancy and have something that looks like this:
Read on.
This solution assumes you have a calc field on a project form called "Project Updates_" that looks like this:
CONCAT("https://YOURDOMAIN.my.workfront.com/project/view?ID=", {ID} , "&activeTab=tab-project-updates")
You would then create a column in your project report that uses this text mode:
column.13.displayname=Latest Update
column.13.linkedname=lastNote
column.13.namekey=view.relatedcolumn
column.13.namekeyargkey.0=lastNote
column.13.namekeyargkey.1=ownerID
column.13.querysort=lastNote:ownerID
column.13.sharecol=true
column.13.textmode=true
column.13.valuefield=lastNote:owner:name
column.13.valueformat=HTML
column.13.width=240
column.14.displayname=Merger2
column.14.sharecol=true
column.14.textmode=true
column.14.value=-
column.14.valueformat=HTML
column.15.displayname=
column.15.linkedname=lastNote
column.15.namekey=view.relatedcolumn
column.15.namekeyargkey.0=lastNote
column.15.namekeyargkey.1=entryDate
column.15.querysort=lastNote:entryDate
column.15.sharecol=true
column.15.styledef.case.0.comparison.icon=false
column.15.styledef.case.0.comparison.leftmethod=lastNote:entryDate
column.15.styledef.case.0.comparison.lefttext=lastNote:entryDate
column.15.styledef.case.0.comparison.operator=notnull
column.15.styledef.case.0.comparison.operatortype=date
column.15.styledef.case.0.comparison.righttext=
column.15.styledef.case.0.comparison.trueproperty.0.name=fontstyle
column.15.styledef.case.0.comparison.trueproperty.0.value=
column.15.styledef.case.0.comparison.truetext=
column.15.textmode=true
column.15.valuefield=lastNote:entryDate
column.15.valueformat=longAtDate
column.16.displayname=Merger1
column.16.sharecol=true
column.16.textmode=true
column.16.value=<br>
column.16.valueformat=HTML
column.17.displayname=Latest Update
column.17.linkedname=lastNote
column.17.namekey=view.relatedcolumn
column.17.namekeyargkey.0=lastNote
column.17.namekeyargkey.1=noteText
column.17.querysort=lastNote:noteText
column.17.sharecol=true
column.17.textmode=true
column.17.valueexpression=IF(LEN({lastNote}.{noteText})>140, CONCAT(SUBSTR({lastNote}.{noteText},0,130),"..."), CONCAT({lastNote}.{noteText}))
column.17.valueformat=HTML
column.18.sharecol=true
column.18.textmode=true
column.18.value=
column.18.valueformat=HTML
column.18.width=1
column.19.displayname=Link
column.19.link.url=customDataLabelsAsString(Project Updates_)
column.19.linkedname=html(URL)
column.19.textmode=true
column.19.valueexpression=IF(ISBLANK({DE:Project Updates_}),"","Link")
column.19.valueformat=HTML
Just paste it in and the columns will renumber themselves.
TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
I want the last system update though, the bold item without my photo by it.
Views
Replies
Total Likes
I think what you're looking for is a Journal report where it shows the object (project/Task), the field name, the change type, The object changed, old value, new value. If you're looking for just a list of system updates the way they're displayed in the updates section, I've never seen that done.
Here is an explanation of the "Note" fields gathered from my tests and coupled with an explanation from Workfront Support.
I wanted to utilize this to pull the project updates into a task report. I got everything to work but the url link. Can you take a look at what I had added below and let me know where it might have gone wrong?
column.6.displayname=Latest Update
column.6.linkedname=lastNote
column.6.namekey=view.relatedcolumn
column.6.namekeyargkey.0=lastNote
column.6.namekeyargkey.1=ownerID
column.6.querysort=project:lastNote:ownerID
column.6.sharecol=true
column.6.textmode=true
column.6.valuefield=project:lastNote:owner:name
column.6.valueformat=HTML
column.6.width=240
column.7.displayname=Merger2
column.7.sharecol=true
column.7.textmode=true
column.7.value=-
column.7.valueformat=HTML
column.8.displayname=
column.8.linkedname=lastNote
column.8.namekey=view.relatedcolumn
column.8.namekeyargkey.0=lastNote
column.8.namekeyargkey.1=entryDate
column.8.querysort=project:lastNote:entryDate
column.8.sharecol=true
column.8.styledef.case.0.comparison.icon=false
column.8.styledef.case.0.comparison.leftmethod=lastNote:entryDate
column.8.styledef.case.0.comparison.lefttext=lastNote:entryDate
column.8.styledef.case.0.comparison.operator=notnull
column.8.styledef.case.0.comparison.operatortype=date
column.8.styledef.case.0.comparison.righttext=
column.8.styledef.case.0.comparison.trueproperty.0.name=fontstyle
column.8.styledef.case.0.comparison.trueproperty.0.value=
column.8.styledef.case.0.comparison.truetext=
column.8.textmode=true
column.8.valuefield=project:lastNote:entryDate
column.8.valueformat=longAtDate
column.9.displayname=Merger1
column.9.sharecol=true
column.9.textmode=true
column.9.value=<br>
column.9.valueformat=HTML
column.10.displayname=Latest Update
column.10.linkedname=lastNote
column.10.namekey=view.relatedcolumn
column.10.namekeyargkey.0=lastNote
column.10.namekeyargkey.1=noteText
column.10.querysort=project:lastNote:noteText
column.10.sharecol=true
column.10.textmode=true
column.10.valueexpression=IF(LEN({project}.{lastNote}.{noteText})>140, CONCAT(SUBSTR({project}.{lastNote}.{noteText},0,130),"..."), CONCAT({project}.{lastNote}.{noteText}))
column.10.valueformat=HTML
column.11.sharecol=true
column.11.textmode=true
column.11.value=
column.11.valueformat=HTML
column.11.width=1
column.12.displayname=Link
column.12.link.url=customDataLabelsAsString(project:Project Updates_)
column.12.linkedname=html(URL)
column.12.textmode=true
column.12.valueexpression=IF(ISBLANK({project}.{DE:Project Updates_}),"","Link")
column.12.valueformat=HTML
Views
Replies
Total Likes
I created a report for these types of updates, using a Note report and adding this text mode in a column:
name=Update Information
textmode=true
valueexpression=IF(!ISBLANK({noteText}),{noteText},CONCAT("SYSTEM UPDATE: ",{auditText}))
valueformat=HTML
Views
Replies
Total Likes
Ah yes. I believe that's what the OP was looking for; auditText. Thanks for catching that!
Is there a way to have only the system updates? When using this textmode is seems to be also pulling in comments.
Views
Replies
Total Likes
Views
Like
Replies