Sorting in Proof Approval Report | Community
Skip to main content
March 31, 2025
Solved

Sorting in Proof Approval Report

  • March 31, 2025
  • 1 reply
  • 476 views

We need to sort a Proof Approval report by "Title". The sorting is not happening with the below text mode code. Does anyone help us on this?

 

displayname=Title
linkedname=documentVersion:document:project:name
namekey=view.relatedcolumn
namekeyargkey.0=documentVersion
namekeyargkey.1=document
namekeyargkey.2=project
namekeyargkey.3=name
querysort=documentVersion:document:project:name
sortOrder=1
sortType=asc
valueexpression={documentVersion}.{document}.{project}.{name}
valueformat=Compound

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Sven-iX

Hi @karthickna1 
Thank you - I used a doc approval report instead of Proof Approval sorry about that! 

 

I am baffled that you get from proofApproval via DOCV to the project... Good to know!

 

I see the same as you - even though the toggle in the column header changes, the sort does not. Might be a bug - did you raise a ticket?

1 reply

Sven-iX
Community Advisor
Community Advisor
March 31, 2025

This {documentVersion}.{document}.{project}.{name} won't work becauswe you cannot get to the project object from the document object. It's a WF limitation.

 

If you must get to project on a VERSION report, no way around but adding a custom field tot he document (eg {project}.{name}) and using that in the report. 

 

On a DOCV report you can only get to the parent DOCU properties, cannot access references.

April 1, 2025

Hi Sven-iX,

 

Thank you for your response. Actually, the text mode code is working fine and we are getting the Project Title. We are looking for the suggestions to make the sorting work.

Sven-iX
Community Advisor
Sven-iXCommunity AdvisorAccepted solution
Community Advisor
April 1, 2025

Hi @karthickna1 
Thank you - I used a doc approval report instead of Proof Approval sorry about that! 

 

I am baffled that you get from proofApproval via DOCV to the project... Good to know!

 

I see the same as you - even though the toggle in the column header changes, the sort does not. Might be a bug - did you raise a ticket?