Sorting in Proof Approval Report

[KarthickNa1]

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

[Sven-iX]

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.

[KarthickNa1]

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 · Accepted solution]

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?

[KarthickNa1]

Hi @Sven-iX 

No worries and thank you for confirming that the sorting is not working. 

We did not raise a ticket yet as we thought we are missing something here.