Expand my Community achievements bar.

Document Folders on Report

Avatar

Level 2
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
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 10

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

Avatar

Level 4

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.