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
PamelaMi
Level 3
Aug 17, 2020 4:53 PM UTC
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.

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.
    AdinaPi1Accepted solution
    Level 9
    Aug 17, 2020 6:02 PM UTC

    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

    View reply

    4 replies

    AdinaPi1
    Level 9
    Sep 24, 2020 8:20 PM UTC

    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).

    Translate
    AdinaPi1Accepted solution
    Level 9
    Aug 17, 2020 6:02 PM UTC

    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

    Translate
    PamelaMiAuthor
    Level 3
    Aug 17, 2020 6:13 PM UTC
    Perfect! Thank you Adina! Appreciate the help.
    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...