Sort by value instead of display inside a report

[Philippe]

In the report below the Sponsor Type dropdown is sorted based on the value of the SponsorTypeID and not its display value. This is working fine. Now I would like the report itself to sort based on the SponsorTypeID as for the dropdown but show the display value  which is SponsorType. I could probably rename my SponsorType like 0 - Platinum, 1- Gold, 2- Silver and so on, but I think this is ugly and looking for a better solution.
Thanks

[Hastur]

@Philippe

It seems like such a standard functionality is not available at the moment.
However, you can suggest implementing this feature at Caspio IdeaBox - http://ideabox.caspio.com/forums/164206-caspio-bridge

[Hastur]

@Philippe

Also, I have found the JS workaround for your case.
You can use your approach with prefixes to sort the Display Values and then slice this prefix.
Example:  01Platinum, 02Gold...

Here is the code:

<script type="text/javascript">
document.addEventListener('DataPageReady', function (event) {
 document.querySelectorAll('.cbResultSetGroup1LabelCell').forEach((element)=>{
  element.innerHTML= element.innerHTML.slice(2);
 });
});
</script>

The thing you need to change is the Class element value within .querySelectorAll() function.

Please find the test app with the same logic implemented attached.New_Application_1_0_2019-Jun-20_0731.zip