User attempts to sort by the entity name field and does not behave as expected

I have a Tempo Task report that is showing tasks for a certain process. The Task Report has a column called Entity that corresponds to a Entity ID that is contained in a pv in the process. I am using a separate query to pull all of the relevant Entity CDTs and then using the displayvalue() function to display the Entity Name in the report instead of the Entity ID. So far so good.

If a user attempts to sort by the Entity Name field it does not behave as the user expects. Since the column is actually backed by the Entity ID in the PortalReportDataSubset, the report sorts in order of Entity ID instead of alphabetically by Entity Name (the value that is being displayed to the user).

Has anyone encountered any good work arounds?

OriginalPostID-137632

OriginalPostID-137632

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data