Sorting by results of a valueexpression? | Community
Skip to main content
L
LinnieCi
Level 4
April 27, 2020
Question

Sorting by results of a valueexpression?

  • April 27, 2020
  • 2 replies
  • 1032 views

Hello,

Does anyone know if it's possible to force sort the results of a valueexpression in a report?

For example, I'm creating an issue report with a column that shows the resolving project's Last Update Date. If the issue does not have a resolving project, then the issue's Last Update Date will display instead:

displayname=Last Update Date

textmode=true

valueexpression=IF(ISBLANK({resolveProject}.{lastUpdateDate}),{lastUpdateDate},{resolveProject}.{lastUpdateDate})

valueformat=atDate

I would like to sort by this column first, then have the results sort in descending order, so I added this code to the above:

sortOrder=1

sortType=desc

However, this completely broke the report, so I may be totally off track with this approach. Any help would be greatly appreciated!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    T
    TegwynSt1
    Level 6
    April 27, 2020

    Hi Linnie,

    this sounds like a report I could use,

    especially now that we are not converting every issue to a project and need that update view.

    if you don't mind sharing I'd like to see it and see answer to your question.

      L
      LinnieCiAuthor
      Level 4
      April 27, 2020

      Hi Tegwyn, sure thing. This is a screenshot from the issue report I'm working on. "Last Update Date" is the column that uses the text mode code I mentioned in my initial post. Seems to work great except for the sorting issue.

      displayname=Last Update Date

      textmode=true

      valueexpression=IF(ISBLANK({resolveProject}.{lastUpdateDate}),{lastUpdateDate},{resolveProject}.{lastUpdateDate})

      valueformat=atDate

      The Project Team column you see here is also text mode. It shows users on the project team of the issue's resolving project. I use this:

      displayname=Project Team

      listdelimiter=<div>

      listmethod=nested(resolveProject.projectUsers).lists

      textmode=true

      type=iterate

      valueexpression={user}.{name}

      valueformat=HTML

      "Original Request Queue Topic" is just the queue topic name field from the standard builder.

      T
      TegwynSt1
      Level 6
      April 27, 2020
      This is awesome – thank you so much! I hope you get an answer!!!!
        ChrisBudgen
        ChrisBudgen
        Level 5
        May 4, 2020

        According to WF Support this currently not possible:

        I just heard from our Reporting team on this. Apparently they also suggested the same workaround as currently there is no way to sort on valueexpression directly. I know that our Reporting development teams are currently working on a new reporting targeted for late 2020 however I am not aware if this functionality or similar features can be included. Some other functionalities I have seen are very advanced such as flexible filtering of date selection, value comparison etc directly on the final reporting screen which will be very handy without going back and forth to the report builder screen.

          L
          LinnieCiAuthor
          Level 4
          May 4, 2020

          Good to know, thank you for passing that along.

          Terms & ConditionsAccessibility statement

          Loading footer...