Display a filtered list of people on a project report | Community
Skip to main content
A
AmandaCr
Level 3
January 10, 2022
Solved

Display a filtered list of people on a project report

  • January 10, 2022
  • 1 reply
  • 783 views

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by nryan2

    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

    1 reply

    N
    nryan2Accepted solution
    Level 3
    January 11, 2022

    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

      A
      AmandaCrAuthor
      Level 3
      January 11, 2022

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

      Terms & ConditionsAccessibility statement

      Loading footer...