This article shows you how to show fields with several values, such as Owners, Divisions and Assignees, in one cell of a report.
Applies to: System administrators (
adminrole) ยท Module: Set up > Reports
Why These Fields Need Extra Code #
A plain marker such as {{data:risk/reference}} works for single values. Owners, Divisions and Assignees can hold several values, so the marker must say which part of each value to show (fold) and how to separate them (join).
The fold Function #
Add |fold(...) after the field key:
- Owners and assignees:
fold(name)orfold(email). - Divisions:
fold(path)for the full path (for example Company/UK/IT) orfold(name)for the last part only (IT).
The join Function #
Wrap the marker and add :join(...) with the separator to put between values, for example :join(, ) or :join(; ).
Putting it together, from the shipped Risk Register (Basic) template:
{{data:generic/divisions|fold(path)}:join(; )}{{data:generic/owners|fold(name)}:join(, )}

The Output #
Each cell shows all the values with your separator, for example Admin Account or Company/UK/Operations. With two owners it would read Owner One, Owner Two.

