I have the following text mode for a column in a project report that populates the entire project user list. I am looking for help on how to adjust this to include only the project user with the job role of designer. | Community
Skip to main content
P
PamelaMi
Level 3
August 17, 2020
Solved

I have the following text mode for a column in a project report that populates the entire project user list. I am looking for help on how to adjust this to include only the project user with the job role of designer.

  • August 17, 2020
  • 2 replies
  • 766 views

displayname=Project Users

listdelimiter=<br>

listmethod=nested(projectUsers).lists

textmode=true

type=iterate

valueexpression={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 AdinaPi1

    I got this to work on my project report. You can also use {roleID} instead of {role}.{name} if you want.

    displayname=Designers

    listdelimiter=<br>

    listmethod=nested(projectUserRoles).lists

    textmode=true

    type=iterate

    valueexpression=IF({role}.{name}="Designer",{user}.{name},"")

    valueformat=HTML

    2 replies

    A
    AdinaPi1Accepted solution
    Level 9
    August 17, 2020

    I got this to work on my project report. You can also use {roleID} instead of {role}.{name} if you want.

    displayname=Designers

    listdelimiter=<br>

    listmethod=nested(projectUserRoles).lists

    textmode=true

    type=iterate

    valueexpression=IF({role}.{name}="Designer",{user}.{name},"")

    valueformat=HTML

    P
    PamelaMiAuthor
    Level 3
    August 17, 2020
    Perfect! Thank you Adina! Appreciate the help.
    A
    AdinaPi1
    Level 9
    September 24, 2020

    Hi Pam, I don't know of a way to sort by a valueexpression derived value. Maybe someone else can verify (or has a way).

    Terms & ConditionsAccessibility statement

    Loading footer...