sorting by computed fields in a report

[JensN.]

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 

[MichaelChatel]

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.

[JensN.]

Hi Michael,

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

kind regards, Jens

[MichaelChatel]

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

[dthierjung]

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

[JensN.]

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

[dthierjung]

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

[KaelLizak]

Hello Dominik Thierjung‌,

As a result of our transition from RFCs to SPRs, enhancements are no longer tracked in Integrity.  Instead, they are tracked with Enhancement Ideas through the Customer Community.  This is the direct link to the Integrity Ideas page.  It doesn't look like this idea has been promoted on the Ideas page.

Regards,
Kael