Expand my Community achievements bar.

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.

Avatar

Level 4

displayname=Project Users

listdelimiter=<br>

listmethod=nested(projectUsers).lists

textmode=true

type=iterate

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

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 solution in original post

4 Replies

Avatar

Correct answer by
Level 8

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

Avatar

Level 4
Perfect! Thank you Adina! Appreciate the help.

Avatar

Level 4

Hi Adina,

You helped me with this text mode a few weeks ago and it's worked perfectly. Do you know if there is a way to add to this to make this column sortable in my report view?

thanks in advance. :)

Pam

Avatar

Level 8

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