Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Document Folders on Report

Avatar

Level 1
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.

1 Reply

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 3

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.