Reporting On The Number of Proof Versions In A Project, Including Comment Count

[Eric_D_Miller]

Hello,

I am attempting to run a report that displays the number of proof versions in a Project. I found this link to achieve this but I was hoping to stretch this even further by including the # of comments on each proof version.

My output currently looks like this:

displayname=Proofs - Version
listdelimiter=<br>
listmethod=nested(documents).lists
textmode=true
type=iterate
valueexpression=IF(ISBLANK({currentVersion}.{proofID}),"",CONCAT({name}," - ",{currentVersion}.{version}))
valueformat=HTML

The highlighted shows the number of versions but ideally I would have each version as it's own line item, with the number of comments for each. I am running a Project report currently. The ultimate ask is to see both the number of proof versions per project and how many comments are posted on each version.

Thank you!

[skyehansen]

Just as you can't get "number of projects" from a portfolio or program report, you similarly cannot get "number of comments" from a project or proof report. If that's important to you, you should be looking at a note report and trying to see if you can group it by document version's version number.

[Eric_D_Miller]

Document version is not coming up in the field list. Is there a textmode that might achieve the grouping for Document Version?

[skyehansen]

You'd have to look at the API explorer. There might or might not be one (looking at going through the document), but you might instead be able to get close by grouping the notes by either proofID or proof name.