Static grid v2 - Group or sort by friendly name in drop down column

Hi guys, i've made a custom screen, that is showing a value in a field in a drop down field in the grid, which is working just fine - if the customer then choses the "Group by" option on the column, it groups the values based on the id of the underlying field, and not by the friendly value ( of the dropdown array):

How can i get it to use a friendly value for grouping, instead of the number? Same goes for sorting, as it will sort based on the number and not the friendly value.

 

Thanks in advance.

RE: Static grid v2 - Group or sort by friendly name in drop down column

Hi Dennis.

Its not pretty, but I've found a work-around.

In front of the ID for each listitem I've added the name of the list-ID like so: "Horse|42". 

When saving and setting the listitem I just accounts for this :D.

 

Von: Kasper Rosenlund 4. Mrz 2020