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

[Kurumi]

For sorting the values in the Dropdown, you can check this forum post: 

Here are some references:

Numerical

- https://stackoverflow.com/questions/71075997/jquery-how-to-sort-list-text-taking-into-account-numerical-values
- https://codepen.io/AdamCCFC/pen/ZWpZLE

Alphabetical

- https://stackoverflow.com/questions/61460640/custom-sort-of-dropdown-options-using-jquery
- https://stackoverflow.com/questions/54479381/jquery-order-select-box-with-numbers
- https://stackoverflow.com/questions/12073270/sorting-options-elements-alphabetically-using-jquery