Sort in list view a to z and z to a working as vice versa for State field

[dharani2607]

Hello,

The sort option in list view is working as vice versa,

Eg: a to z - Displays in Descending order

z to a - Displays in Ascending order

[suvro]

The backend values of the state is integer check the integer values

[dharani2607]

Any way to fix this?

[suvro]

There is no need to change this or fix this as integer values are defined as per the order they execute like New-> then Work In Progress -> Resolved --> Closed. 

So it is absolutely proper AND whenever you see those in list sorted in ascending order it should show all the new records 1st then work in progress ones . It does makes sense. Sorting the state alphabetically does not make sense.

Even if you want to do it. It involves changing the back-end values to string instead of integer but that may affect many scripts that are using the back-end values

[SumanthDosapati]

Hi @dharani2607 ,

Sorting will not be based on Label of choices.

Sorting will be based on value of choices.

State field may have different label and value like integer.

Mark as correct and helpful if it solved your query.

Regards,
Sumanth