pull document names into project report

[scott_tupper]

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

[Richard_Le_ · Accepted solution]

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.

[scott_tupper]

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

[RodWin]

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

[scott_tupper]

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.

[Richard_Le_]

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. 

[scott_tupper]

Thank you!

[Matt_McC]

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