Nested Document List to Show Approval Report

[MattWindsor]

Hi,

Can anyone help me with trying to get the document approval date to show in this field please? I've added {currentVersion}.{approvalDate} but it does nothing. I'm in a project report.

displayname=Quote Approval Date
listdelimiter=<p>
listmethod=nested(documents).lists
type=iterate
valueexpression=IF(!ISBLANK({currentVersion}.{proofID}),IF(CONTAINS("Quote",{currentVersion}.{fileName}),{currentVersion}.{approvalDate},""),"")
valueformat=HTML
width=200

Thanks

Matt

[AshpektSolutions · Accepted solution]

It seems you’re trying to access the document approval field from the Project (parent) object, which isn’t directly available and that is the reason you're getting nothing / blank.

The easier approach is to create a Document Approval Report, where the Approval Date field is by default and you can then filter it for documents containing “Quote”.

Alternatively, you can capture this value using Fusion and store it in a custom field on the Project, so it’s visible in your Project Report.

[MattWindsor]

Hi, thanks for the information. I'm going to go down the separate report to pull in this information as we don't use Fusion.

Thanks again!
Matt