Reporting On The Number of Proof Versions In A Project, Including Comment Count | Community
Skip to main content
Eric_D_Miller
Eric_D_Miller
New Participant
April 9, 2025
Question

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

  • April 9, 2025
  • 1 reply
  • 546 views

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!

1 reply

skyehansen
skyehansen
New Participant
April 9, 2025

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
Eric_D_MillerAuthor
New Participant
April 9, 2025

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

skyehansen
skyehansen
New Participant
April 9, 2025

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.

Terms & ConditionsAccessibility statement

Loading footer...