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
