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. | Adobe Higher Education

Level 3

해결됨

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.

Forum|Forum|5 years ago
August 17, 2020
2 답변들
766 조회

displayname=Project Users

listdelimiter=<br>

listmethod=nested(projectUsers).lists

textmode=true

type=iterate

valueexpression={user}.{name}

valueformat=HTML

이 주제는 답변이 닫혔습니다.

최고의 답변: 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

Level 9

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

PamelaMi작성자

Level 3

Perfect! Thank you Adina! Appreciate the help.

Level 9

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