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? | Community
Skip to main content
P
PamelaMi
Level 3
September 24, 2020
Question

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?

  • September 24, 2020
  • 2 replies
  • 697 views

displayname=Designers

listdelimiter=<br>

listmethod=nested(projectUserRoles).lists

textmode=true

type=iterate

valueexpression=IF({role}.{name}="Designer",{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.

    2 replies

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    September 24, 2020

    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

      P
      PamelaMiAuthor
      Level 3
      September 24, 2020
      Thank you Doug, I will give this a try.
      P
      PatriciaGr
      Level 3
      September 28, 2020

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

      Terms & ConditionsAccessibility statement

      Loading footer...