Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Avatar

Level 1

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

0 Replies