Document Folders on Report | Community
Skip to main content
K
KatyRe
Level 1
August 28, 2017
Question

Document Folders on Report

  • August 28, 2017
  • 1 reply
  • 1039 views
Hi, Is it possible to group or add a field on a documents report showing the folder each document is located in on a project? Thanks, Katy Katy Reid Menzies Distribution Ltd
    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    P
    PollyCo
    Level 9
    August 28, 2017

    You can show the folders on a document report by text mode.

    displayname=Folder

    listdelimeter=<br>

    listmethod=nested(folders).lists

    textmode=true

    type=iterate

    valueexpression={name}

    valueformat=HTML

    Optionally, you can also show the parent folders name in the column.

    displayname=Folder

    listdelimeter=<br>

    listmethod=nested(folders).lists

    textmode=true

    type=iterate

    valueexpression=CONCAT({parent}.{name}," / ",{name})

    valueformat=HTML

      S
      stuartcairns
      Level 4
      May 19, 2022

      This is really useful. Is there a way to allow sorting by the folder column in the report? I've added the 'querysort=' parameter but I'm struggling to get the syntax right. Thanks v much.

      Terms & ConditionsAccessibility statement

      Loading footer...