Skip to main content
J
JensN.1-Visitor
1-Visitor
May 2, 2016
Question

sorting by computed fields in a report

  • May 2, 2016
  • 2 replies
  • 2703 views

Hi @all,

it seems that ist not possible in a report to sort by fields, which are computed fields. These fields doesnt show in the table in the "Sort by" segamt of the reprting wizard. Are there any workarounds for this?

Thanks, Jens 

    2 replies

    M
    MichaelChatel5-Regular Member
    5-Regular Member
    May 2, 2016

    Hi Jens-Uwe,

    You are correct that you're not able to "sort by" computed fields, in the manner in which you are looking for, in the Report wizard.  You could post a product idea - that is definitely a useful idea.

      J
      JensN.1-VisitorAuthor
      1-Visitor
      May 9, 2016

      Hi Michael,

      i think i will open a support-ticket and maybe this will go into a RfC then...

      kind regards, Jens

      M
      MichaelChatel5-Regular Member
      5-Regular Member
      May 9, 2016

      FYI,

       

      Recently, Integrity has aligned with the rest of PTC's Tech Support practices, regarding "enhancements", where such "new functionality" requests, are submitted by customers, as "product ideas". 

       

      Here is a link:

      Windchill Systems/Software Engineering Ideas (Integrity) - PTC Community

       

      RFCs are not used anymore, for "new functionality/enhancement" type of requests, anymore, including the ones that already existed (like the one Dominik referenced).

      D
      dthierjung1-Visitor
      1-Visitor
      May 4, 2016

      Hi Jens-Uwe Nixdorf‌

      as a workaround you could either sort it in javascript (depends on how much data you are trying to sort through) or generate and sort your report serverside (using the java api) and send the result to the user.

      Regards

      Dominik

        J
        JensN.1-VisitorAuthor
        1-Visitor
        May 9, 2016

        Hi Dominik, yes, via Javasript should work, but this isnt a solution for the standard-user, which only wants to use a recipe and some clicks in a wizard...

        kind regards, Jens

        D
        dthierjung1-Visitor
        1-Visitor
        May 9, 2016

        You are right about that.

        You would need to create a new recipe and the effort spend on that is determined on how adapable you need the reports to be. But using javascript and maybe html5 data-* attributes it is definitly doable to make something which is sorted by a specific field value.

        If you look at Support Document CS87599, there is already an enhancement for exactly your request.

        Regards,

        Dominik

        Terms & ConditionsAccessibility statement