Expand my Community achievements bar.

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

Avatar

Level 4

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