Expand my Community achievements bar.

SOLVED

show task comment on proof report

Avatar

Level 5

I have a proof approval report on a dashboard. I can get the document ID to show, can I use the connection from the document ID to get to the the task that the document is on and then the last note on that task?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Got it working! I'm glad I saw this post bc I hadn't thought I could add in a last proof comment into a proof report. I was able to add in who the comment owner was AND the date they left the comment, all in 1 column with line breaks (merged columns for fewer columns). Here is my text mode, of course you'll need to revise your column numbers as needed. Please mark this correct if this helpful for you.

 

column.9.displayname=Most Recent Proof Comment
column.9.linkedname=documentVersion
column.9.namekey=view.relatedcolumn
column.9.namekeyargkey.0=documentVersion
column.9.namekeyargkey.1=documentID
column.9.sharecol=true
column.9.textmode=true
column.9.valuefield=documentVersion:document:project:lastNote:noteText
column.9.valueformat=HTML
column.10.sharecol=true
column.10.textmode=true
column.10.value=<br>
column.10.valueformat=HTML
column.10.width=1
column.11.displayname=Most Recent Proof Comment Owner
column.11.linkedname=documentVersion
column.11.namekey=view.relatedcolumn
column.11.namekeyargkey.0=documentVersion
column.11.namekeyargkey.1=documentID
column.11.sharecol=true
column.11.textmode=true
column.11.valuefield=documentVersion:document:project:lastUpdatedBy:name
column.11.valueformat=HTML
column.12.sharecol=true
column.12.textmode=true
column.12.value=<br>
column.12.valueformat=HTML
column.12.width=1
column.13.displayname=Most Recent Proof Comment Date
column.13.linkedname=documentVersion
column.13.namekey=view.relatedcolumn
column.13.namekeyargkey.0=documentVersion
column.13.namekeyargkey.1=documentID
column.13.textmode=true
column.13.valuefield=documentVersion:document:project:lastUpdateDate
column.13.valueformat=HTML

If this helped you, please mark correct to help others : )

View solution in original post

3 Replies

Avatar

Community Advisor

Hi there, I have a proof approval report where I have a column for showing the project is in, since sometimes people put it with a task or the project. Put this in the text mode of the column:

displayname=Project
link.valuefield=documentVersion:document:project:name
link.valueformat=HTML
textmode=true

 

You could give it a shot to replace 'project' with 'task' but not sure if it'll work.
And instead of the doc ID, which means nothing to us usually, I have another column that is a link to the proof so people can go to the proof straight from the report:
displayname=Proof Link
textmode=true
valueexpression=CONCAT("https://micron.my.workfront.com/document/",{documentVersion}.{document}.{ID},"/proof/",{documentVersion}.{proofID},"/view")
valueformat=HTML

Good luck! If this helps, go ahead and mark this answer as correct to help others : )

If this helped you, please mark correct to help others : )

Avatar

Level 5

So, I have gotten the note text to show:

displayname=Test
linkedname=documentVersion
namekey=view.relatedcolumn
namekeyargkey.0=documentVersion
namekeyargkey.1=documentID
textmode=true
valuefield=documentVersion:document:project:lastNote:noteText
valueformat=HTML

 

I'm try to add the name of the note's owner. This is what hasn't worked:

 

This one gets you a whoops error and doesn't show the report:

displayname=Test
linkedname=documentVersion
namekey=view.relatedcolumn
namekeyargkey.0=documentVersion
namekeyargkey.1=documentID
textmode=true
valuefield=documentVersion:document:project:lastNote:owner:name
valueformat=HTML

 

These gets a blank column

valuefield=documentVersion:document:project:lastNote:ownerID:Name

valuefield=documentVersion:document:project:lastNote:ownerName

 

any ideas to get the note's owner to show?

 

Avatar

Correct answer by
Community Advisor

Got it working! I'm glad I saw this post bc I hadn't thought I could add in a last proof comment into a proof report. I was able to add in who the comment owner was AND the date they left the comment, all in 1 column with line breaks (merged columns for fewer columns). Here is my text mode, of course you'll need to revise your column numbers as needed. Please mark this correct if this helpful for you.

 

column.9.displayname=Most Recent Proof Comment
column.9.linkedname=documentVersion
column.9.namekey=view.relatedcolumn
column.9.namekeyargkey.0=documentVersion
column.9.namekeyargkey.1=documentID
column.9.sharecol=true
column.9.textmode=true
column.9.valuefield=documentVersion:document:project:lastNote:noteText
column.9.valueformat=HTML
column.10.sharecol=true
column.10.textmode=true
column.10.value=<br>
column.10.valueformat=HTML
column.10.width=1
column.11.displayname=Most Recent Proof Comment Owner
column.11.linkedname=documentVersion
column.11.namekey=view.relatedcolumn
column.11.namekeyargkey.0=documentVersion
column.11.namekeyargkey.1=documentID
column.11.sharecol=true
column.11.textmode=true
column.11.valuefield=documentVersion:document:project:lastUpdatedBy:name
column.11.valueformat=HTML
column.12.sharecol=true
column.12.textmode=true
column.12.value=<br>
column.12.valueformat=HTML
column.12.width=1
column.13.displayname=Most Recent Proof Comment Date
column.13.linkedname=documentVersion
column.13.namekey=view.relatedcolumn
column.13.namekeyargkey.0=documentVersion
column.13.namekeyargkey.1=documentID
column.13.textmode=true
column.13.valuefield=documentVersion:document:project:lastUpdateDate
column.13.valueformat=HTML

If this helped you, please mark correct to help others : )