Anyone know the text mode for a large thumbnail preview column in a PROOF APPROVAL report? | Community
Skip to main content
MoniqueEvans
Community Advisor
MoniqueEvansCommunity Advisor
Community Advisor
August 31, 2022
Question

Anyone know the text mode for a large thumbnail preview column in a PROOF APPROVAL report?

  • August 31, 2022
  • 1 reply
  • 2208 views

I have a Proof Approval report and I'm trying to add an additional column to display a preview (large thumbnail) of the document. I'm hoping it's not too many jumps to get from proof approval to document version to document large thumbnail.

    1 reply

    R
    Community Advisor
    Richard_Le_Community Advisor
    Community Advisor
    September 1, 2022

    Hey Monique,

     

    So this is the only textmode I have, which will pull in a thumbnail on proof approval report, but not all file types are supported so not a great solution (namely pdf files, often the most proofed format!)

     

    displayname=Thumbnail
image.valuefield=documentVersion:document:previewURL
textmode=true
type=image
valuefield=documentVersion:document:previewURL
valueformat=HTML

    Are you able to achieve the same report requirements using a document version report instead? Thumbnail is natively available in this type of report (and PDF's supported).

     

    Best Regards,

    Rich. 

      MoniqueEvans
      Community Advisor
      MoniqueEvansCommunity AdvisorAuthor
      Community Advisor
      September 13, 2022

      Thanks, Richard this helps! Unfortunately, it only seems to work for select proofs; and I can't figure out the reason.

      C
      christinequick
      Level 2
      March 6, 2024

      Was Support able to give any support on this? I would love to have thumbnails on a report for either proofs or documents!


      I was able to make a Document Version report work with this filter:

       

      EXISTS:1:$$OBJCODE=DOCU

      EXISTS:1:ID=FIELD:documentID

      EXISTS:1:project:status=CUR

      EXISTS:1:project:status_Mod=in

      EXISTS:2:$$OBJCODE=PRFAPL

      EXISTS:2:approverID=$$USER.ID

      EXISTS:2:approverID_Mod=in

      EXISTS:2:documentVersionID=FIELD:ID

      EXISTS:2:isAwaitingDecision=true

      EXISTS:2:isAwaitingDecision_Mod=eq

      isCurrentVersion=true

      isCurrentVersion_Mod=eq

      proofDecision=pending

      proofDecision_Mod=cieq

      proofID_Mod=notblank

       

       

      If you need a proof deadline column, use this text mode:

      displayname=Proof Deadline

      querysort=proofDeadlineDate

      textmode=true

      valuefield=proofDeadlineDate

      valueformat=atDate

       

      Thumbnail:

      use Document > Thumbnail

       

      Project Name:

      displayname=Project

      linkedname=document

      namekey=view.relatedcolumn

      namekeyargkey.0=document

      namekeyargkey.1=project:name

      querysort=document:project:name

      sharecol=true

      shortview=true

      textmode=true

      valueexpression={document}.{project}.{name}

      valueformat=HTML

       

      Approvers:

      displayname=Approvers

      listdelimiter=<p>

      listmethod=nested(proofApprovals).lists

      textmode=true

      type=iterate

      valueexpression=CONCAT("• ",{approver}.{name})

      valueformat=HTML

      Terms & ConditionsAccessibility statement

      Loading footer...