Question for Sorting implementation for priority

0
Everyone We need to sort a 'Priority' column that has the following values:   Critical (stored as 1) Medium (stored as 2) Low (stored as 3) When I sort the column in descending order (largest to smallest), the Low priority items appear at the top because they are stored as 3. However, I don’t want to store the priorities in reverse order (i.e., Critical as 3, Medium as 2, and Low as 1).What other options are available in Mendix to achieve the desired sorting without changing the way the data is stored?
asked
3 answers
1

Why not then sort the column ascending instead of descending? Or am I missing the problem?

 

Regards,

Ronald

 

answered
0

Hi Saurav,

 

Make it ascending order which will bring smallest to largest.

 

Hope it helps!

Thanks & Regards,

Manikandan K

 

answered
0

image.png

 

I am using this type  of button because my data is : Critical (stored as 1)Medium (stored as 2)Low (stored as 3)When I say desc it show the Low priority records on top.

answered