Expand my Community achievements bar.

SOLVED

pull document names into project report

Avatar

Level 1

Hello WF Collective.

I know once entering text mode just about anything is possible, but I am unable to pull document names and file types into a project report.

This works just fine in a document report but in a project report, it simply pulls in the project name, so do I need to tweak the syntax somehow?  Many thanks in advance for your time.

 

link.linkproperty.0.name=ID
link.linkproperty.0.valuefield=ID
link.linkproperty.0.valueformat=string
link.lookup=document.directory
link.value=val(isDir)
listsort=string(name)
namekey=name
querysort=name
stretch=0
textmode=true
valuefield=name
valueformat=HTML
width=170

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi Scott,

 

Using the following text mode in a project report will return the name of all of the documents stored against each project:

displayname=Documents
listdelimiter=<br>
listmethod=nested(documents).lists
textmode=true
type=iterate
valuefield=name
valueformat=HTML

Best Regards,

Rich.

View solution in original post

7 Replies

Avatar

Correct answer by
Community Advisor

Hi Scott,

 

Using the following text mode in a project report will return the name of all of the documents stored against each project:

displayname=Documents
listdelimiter=<br>
listmethod=nested(documents).lists
textmode=true
type=iterate
valuefield=name
valueformat=HTML

Best Regards,

Rich.

Avatar

Level 1

Thank you Richard this totally works!  I was hoping though that I could also pull the file type but it appears that I cannot simply substitute documents for filetype.  Is this particular function not possible?

Thanks again for getting me this far.

 

displayname=Type
listdelimiter=<br>
listmethod=nested(filetype).lists
textmode=true
type=iterate
valuefield=name
valueformat=HTML

Avatar

Level 3

Create another column with the same nested(documents).list but change the valuefield.

displayname=File Types
listdelimiter=<br>
listmethod=nested(documents).lists
textmode=true
type=iterate
valuefield=fileType
valueformat=HTML

Because you are working through a collection, the two lists may not come out in the same order.  You could try...

displayname=Documents & File Type
listdelimiter=<br>
listmethod=nested(documents).lists
textmode=true
type=iterate
valueexpression=CONCAT({name}," - ",{fileType})
valueformat=HTML

 

Avatar

Level 1

Hello Rod and thanks for your response.  The first example is returning a generic error.  The second example is only pulling the name of the document but not the file type.

I appreciate the help though.

Avatar

Community Advisor

Hi Scott,

 

Try the following code instead, this should do it.

 

displayname=Documents
listdelimiter=<br>
listmethod=nested(documents).lists
textmode=true
type=iterate
valueexpression=CONCAT({name},".",{currentVersion}.{ext})
valueformat=HTML

Best Regards,

Rich. 

Avatar

Level 4

Hi Scott,

 

I know I am late to the party, but with a simple tweak you can include a link to the doc.

 

valueexpression=CONCAT({name},".",{currentVersion}.{ext}," - https://YOUR_INSTANCE_HERE.my.workfront.com/document/view?ID=",{ID})
listdelimiter=<br>
listmethod=nested(documents).lists
valueformat=HTML
displayname=Documents
textmode=true
type=iterate

 I hope it helps.

 

Matt