Document Link on Project Report

Question

I'm trying to create a column that will display the link to a brief document on a project. I tried the below text...and think I hallucinated it working yesterday...but it is not displaying as I expected. Any ideas? displayname=Link to Brieflistdelimiter=

listmethod=nested(project).nested(documents).liststextmode=truetype=iteratevalueexpression=IF(CONTAINS('brief',{name}),CONCAT("http://domain.my.workfront.com/","document/",{ID}, "/details"))valueformat=HTML

ChristianSi6 · Accepted Answer

This is what finally worked. displayname=Link to Brieflistdelimiter=
listmethod=nested(documents).liststextmode=truetype=iteratevalueexpression=IF(CONTAINS('brief',{name}),CONCAT("http://domain.my.workfront.com/","document/",{ID},"/details"))valueformat=HTML

Rafal_Bainie · Answer

couple things:1. in your code there is a mistake with duplicated part in line 3 which I think should read:listmethod=nested(documents).lists 2. I thought it's IF that is causing issues because you are using it almost as filter, but I confirmed it's not IF by removing it3. Following code works just fine on project page, task view:displayname=Listlistdelimiter=

listmethod=nested(documents).liststype=iteratevalueexpression={ID}valueformat=HTML4. exactly the same code doesn't work on portfolio page, project view.5. However, slightly modified code works just fine:displayname=Listlistdelimiter=

listmethod=nested(tasks).liststype=iteratevalueexpression={ID}valueformat=HTMLTherefore I think it's either by design that documents collection won't work on portfolio level OR it's a bug. To verify that I would reach out to support

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded