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

I have the text mode below in a project report to show the name of a user with role as designer. Is there code I can add so the report can be sorted by this column?

Avatar

Level 4

displayname=Designers

listdelimiter=<br>

listmethod=nested(projectUserRoles).lists

textmode=true

type=iterate

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

valueformat=HTML

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

3 Replies

Avatar

Level 10

Hi Pamela,

"Nope". Collections cannot be sorted. As a workaround, you could, however, add a custom parameter at the Project Level called "Designer Role", manually load it with the names of the Designers in your company, and then sort (and filter, and group, and chart) by that field.

I've used this technique in the past many times -- one such dropdown for each key role -- and found it to be very useful. In fact, if you make the value of the dropdown the ID of each user, you can even filter on those key role parameters using $$USER.ID, which has even more advantages.

Regards,

Doug

Avatar

Level 3

You may also try adding User Name as a hidden column and sort on that?