pull document names into project report | Community
Skip to main content
scott_tupper
scott_tupper
January 24, 2023
Solved

pull document names into project report

  • January 24, 2023
  • 1 reply
  • 1471 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Richard_Le_

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.

1 reply

R
Community Advisor
Richard_Le_Community AdvisorAccepted solution
Community Advisor
January 24, 2023

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
scott_tupperAuthor
January 24, 2023

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

R
RodWin
January 25, 2023

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

 

Terms & ConditionsAccessibility statement

Loading footer...