Help with Proof Approval Report Filter by Proof Approver Status = Pending Text Mode | Community
Skip to main content
JamesM-MERGE
Level 4
October 26, 2022

Help with Proof Approval Report Filter by Proof Approver Status = Pending Text Mode

  • October 26, 2022
  • 0 replies
  • 578 views

I am looking for help with my Proof Approval Report with text mode on the Filter to also filter on Proof Approval Status=Pending?

 

Below are the details of my report configuration:

Columns

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

Proof Approval > Proof Creation Date

 

Document Name > text mode:

descriptionkey=document.name
link.linkproperty.0.name=ID
link.linkproperty.0.valuefield=documentID
link.linkproperty.0.valueformat=string
link.lookup=link.view
link.value=nested(documentVersion).nested(document).val(objCode)
namekey=document.name
querysort=documentVersion:document:name
valuefield=documentVersion:document:name
valueformat=HTML
width=100

 

Proof Creator > text mode:

link.linkproperty.0.name=ID
link.linkproperty.0.valuefield=proofedByUserID
link.linkproperty.0.valueformat=string
link.lookup=link.view
link.value=nested(documentVersion).nested(proofedByUser).val(objCode)
namekey=proofedByUser
querysort=documentVersion:proofedByUser:name
textmode=true
valuefield=documentVersion:proofedByUser:name
valueformat=HTML
width=100

 

Document Version > Version

Approver > Name

 

Proof Approval Status > text mode:

displayname=Proof Approval Status
linkedname=documentVersion
namekey=view.relatedcolumn
namekeyargkey.0=documentVersion
namekeyargkey.1=proofApprovalStatus
namekeyargkey.2=proofApprovalStatusLabel
querysort=documentVersion:proofApprovalStatus:proofApprovalStatusLabel
textmode=true
valuefield=documentVersion:proofApprovalStatus:proofApprovalStatusLabel
valueformat=HTML

 

Groupings

Approver > Name

 

Filters

approverDecision=Pending
approverDecision_Mod=cieq
approverID=$$USER.ID
approverID_Mod=in
documentVersion:proofDecision=Pending
documentVersion:proofDecision_Mod=cieq
documentVersion:proofProgress=Decision Made
documentVersion:proofProgress_Mod=cinotcontains
isAwaitingDecision=true
isAwaitingDecision_Mod=eq
isCurrentDocumentVersion=true
isCurrentDocumentVersion_Mod=eq

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.