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?
Solved! Go to Solution.
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
Views
Replies
Total Likes
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 : )
Views
Replies
Total Likes
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?
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
Views
Replies
Total Likes
Views
Likes
Replies