Display a filtered list of people on a project report

[AmandaCr]

Hello!

I have a project report with a text mode column to get the list of people on that project.

Anyone know if there is a way to filter that people list for only certain roles? Just display the people that match a certain role.

Something like this? This doesn't work but is what we're looking to do.

description=Team Users

displayname=CLS

listdelimiter=

listmethod=nested(projectUsers).lists

name=ID

namekey=assignment.plural

projectUsers=role_Mod=in

textmode=true

type=iterate

valueexpression=IF({role}="Corporate Leasing Consultant",{name})

valuefield=user:name

valueformat=HTML

[nryan2 · Accepted solution]

I do something similar that might work for you. It looks for the Copywriter Job Role ID and then lists the names of the assigned copywriters. You would just need to replace the ID with the role ID you want to display.

Here's the code:

displayname=Copywriter

listdelimiter=<div>

listmethod=nested(projectUserRoles).lists

textmode=true

type=iterate

valueexpression=IF({roleID}="a2b230b5fd874762e040007f0100",{user}.{name},"")

valuefield=user:name

valueformat=HTML

[AmandaCr]

That worked beautifully! Thank you so much for the help it's much appreciated!