Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

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