Expand my Community achievements bar.

SOLVED

Display a filtered list of people on a project report

Avatar

Level 6

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

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Level 3

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 3

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

Avatar

Level 6

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