Adding a Decision Date Column to an Approvals Report | Community
Skip to main content
P
Pat_Paterson
Level 4
February 22, 2024
Question

Adding a Decision Date Column to an Approvals Report

  • February 22, 2024
  • 1 reply
  • 720 views

Hi all,

 

I trying to see if it is possible to add a Decision Date column, then sort the column by date (newest to oldest).  I tried the following formula but had no luck:

 

displayname=Decision Date
linkedname=direct
namekey=proofDecisionDate
querysort=proofDecisionDate
valuefield=proofDecisionDate
valueformat=atDate
sortType=asc
sortOrder=1

 

this blows up my report and I get an error message. I've also tried it with the value decisionDate instead of proofDecisionDate but no luck. I've been able to add a similar column with both the approver's name as well as their decision date via the following formula:

 

displayname=Approvers and Dates
listdelimiter=<p>
listmethod=nested(proofApprovals).lists
proofOwnerID=$$USER.ID
proofOwnerID_Mod=in
textmode=true
type=iterate
valueexpression=IF(!ISBLANK({decisionDate}),CONCAT("• ",{approver}.{name}," - ",{decisionDate}),CONCAT("• ",{approver}.{name}))
valueformat=HTML

 

Any help would be greatly appreciated.

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

1 reply

skyehansen
Community Advisor
skyehansenCommunity Advisor
February 22, 2024

I'm a little confused. Are you referring to a proof approval report or some other sort of approval report? If it's the proof approval report, why are you not just using the standard mode Proof Approval / Decision Date?

P
Pat_PatersonAuthor
Level 4
February 22, 2024

My bad, I meant that it was a document version report.

skyehansen
Community Advisor
skyehansenCommunity Advisor
February 22, 2024

I see. So you were able to get a collections column working in the document version report which means that proof approvals are a collection of a document. If you get the dates, you're probably not going to be able to sort them in ascending or descending order... this is just what collections are like.

Terms & ConditionsAccessibility statement

Loading footer...