Return Proof Version Dates

[MattWindsor]

Hi all,

I need to be able to pull the first and second proof dates into a report. So far I have this which pulls in the current version, but I can't make it only look at the earlier versions

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

Thanks

Matt

[skyehansen · Accepted solution]

if you take a look at this article where it says you cannot build a collection view of another collection, this is pretty much what you are asking to do. You're building a report, and pulling in a collection of documents to report on.

Anything you put into your valueexpression should be coming from the fields tab or the references tab at most, in the API explorer. However, the information that you are trying for, would be stored in the document version (and document versions are a collection in every document -- hence collection of a collection in this case means you're trying to build a view by pulling in a collection of documents each with a collection of document versions that has the information you seek). Hope all that makes sense.

Normally at this point, the only way to get this information is to go at least one level down. You can make a document report, and pull in the collection of document versions for the information you seek. Or you can make a document version report and not have to pull in any collections.

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/text-mode/reference-col...

[MattWindsor]

Hi Skye, I came to that same conclusion some time after posting. I think I'm starting to understand the API explorer now.

Thanks for your explanation

Matt