Adding a Project custom field to a Document Version report | Community
Skip to main content
C
christinequick
November 4, 2023
Solved

Adding a Project custom field to a Document Version report

  • November 4, 2023
  • 1 reply
  • 887 views

I'm trying to add a column to a document version report that contains data from a custom field on the project. Here is the code I have, but it's not producing results. Any suggestions?

 

displayname=Asset Type
linkedname=document
namekey=view.relatedcolumn
namekeyargkey.0=document
namekeyargkey.1=project:DE:Asset Type
querysort=document:projectID
textmode=true
valuefield=document:project:DE:Asset Type
valueformat=HTML

Best answer by ajdifonzo

This should work for you, in my example I am using a field that is in my system and below that the same text with your field. I changed "valuefield" to "valueexpression" and used brackets. 

 

displayname=Asset Type
textmode=true
valueexpression={document}.{project}.{DE:MCS - Project Type}
valueformat=HTML

 

 

displayname=Asset Type
textmode=true
valueexpression={document}.{project}.{DE:Asset Type}
valueformat=HTML

1 reply

ajdifonzo
ajdifonzoAccepted solution
November 6, 2023

This should work for you, in my example I am using a field that is in my system and below that the same text with your field. I changed "valuefield" to "valueexpression" and used brackets. 

 

displayname=Asset Type
textmode=true
valueexpression={document}.{project}.{DE:MCS - Project Type}
valueformat=HTML

 

 

displayname=Asset Type
textmode=true
valueexpression={document}.{project}.{DE:Asset Type}
valueformat=HTML

    C
    christinequickAuthor
    November 13, 2023

    Thank you!

     

    Terms & ConditionsAccessibility statement

    Loading footer...