Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

Adding a Project custom field to a Document Version report

Avatar

Level 2

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 3

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 3

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