View Question: Displaying multiple roles in a column

[BenettaPe]

In my view, for those users who have multiple roles, how can I get it to show all roles for each user. This is a view, not a report. Thanks. Benetta Perry APS

[KirstenHe]

Hi Benetta, Try adding a new column, switching to text mode, and entering this: displayname=All Job Roles link.linkproperty.0.name=ID link.linkproperty.0.valuefield=ID link.linkproperty.0.valueformat=int link.lookup=link.view link.value=val(objCode) listdelimiter= listmethod=nested(userRoles).lists namekey=roles.plural textmode=true type=iterate valuefield=role:name valueformat=HTML Kirsten Heikkinen Trek Bicycle Corporation

[BenettaPe]

Kiristen, Thank you. I'm testing and playing around with this now. Benetta Perry APS