Uhhh. Wow. That worked.
If only I understood EXISTS filters 😂
The large thumbnail worked! It wasn't available as a canned field on a proof approval report and the substitute that support gave me would only generate thumbnails for PNGs and JPGs. Here's another question for you though - all of the sudden my text mode for generating a link directly to the proof doesn't work.
displayname=Proof Link
shortview=true
textmode=true
usewidths=true
valueexpression=CONCAT("https://melaleuca.my.workfront.com/document/",{documentVersion}.{ID},"/proof/",{documentVersion}.{proofID},"/view")
valueformat=HTML
width=200
Can I get your thoughts O great and powerful Workfront Wizard?
For anyone running into the issue Samanthalsin is describing...
When you move from a Document report to a Proof Approval report you need to update the syntax of the fields that the URL is using to assemble the link.
Document Report: valueexpression=CONCAT("https://melaleuca.my.workfront.com/document/",{documentVersion}.{ID},"/proof/",{documentVersion}.{proofID},"/view")
Proof Approval Report: valueexpression=CONCAT("https://melaleuca.my.workfront.com/document/",{documentVersion}.{document}.{currentVersion}.{ID},"/proof/",{documentVersion}.{document}.{currentVersion}.{proofID},"/view")
Because we are shifting out target objects when we change reports, we also have to update the targets in the URL we're generating with the valueexpression.
Nothing like finding and resurrecting an old thread with a problem you just ran into and fixed 😄
