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
Solved! Go to Solution.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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.
Thank you!
Views
Replies
Total Likes
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
Views
Likes
Replies
Views
Likes
Replies