Can I add the last system update from the task or project updates to a report?

Forum|Forum|3 years ago
February 9, 2023
3 replies
2927 views

No text available

Workfront

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

Best answer by Sheri_Whitten

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

Richard_Carlson

Community Advisor

New Project Report

Add column

Project >> Status Update

I suspect a similar function would work for Tasks

K

KendraRo2Author

Level 3

I want the last system update though, the bold item without my photo by it.

RandyRoberts

Community Advisor

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.

K

KendraRo2Author

Level 3

I want the last system update though, the bold item without my photo by it.

RandyRoberts

Community Advisor

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.

Last Note: Available on any object that accepts updates.
Any update that is entered directly on the object, or sent directly to or from the object (user on a user report) by anyone, ignoring all others such as Proof Comments or any other child objects. In a user report, these are often private convos.
Last Status Note: User object only. This field is NOT available on Projects, Tasks, Issues, etc.
compares Last Entered Note and Last Update Note and returns the most recent of the two.
Last Entered Note: User object only. This field is NOT available on Projects, Tasks, Issues, etc.
returns the last update a specific user made on their own User page. (No one at Workfront was 100% sure on this one.)
Last Update Note: User object only. This field is NOT available on Projects, Tasks, Issues, etc.
returns the last update a specific user made on any object.
The Last Note entered by the User, ignoring any other subsequent Last Note entries created by other users. A User report lists only the users entries (as they own themselves) even if the update is on another object (proof, project, etc.), These may be private convos.