show task comment on proof report | Community
Skip to main content
D
DreadkiailiWork
January 19, 2023
Solved

show task comment on proof report

  • January 19, 2023
  • 2 replies
  • 1113 views

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?

    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 Madalyn_Destafney

    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

    2 replies

    Madalyn_Destafney
    Community Advisor
    Madalyn_DestafneyCommunity Advisor
    Community Advisor
    January 20, 2023

    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 : )
    D
    DreadkiailiWorkAuthor
    January 20, 2023

    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?

     

      Madalyn_Destafney
      Community Advisor
      Madalyn_DestafneyCommunity AdvisorAccepted solution
      Community Advisor
      January 20, 2023

      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 : )
      Terms & ConditionsAccessibility statement

      Loading footer...