I'm facing an issue when trying to sort the values in a month list box. I'm doing the sort based on a field called MONTH_SHORT_NAME which contains values like JAN, FEB...DEC The object I sort by is MONTH_MONTH_OF_YEAR which is a number from 1 to 12. The sort is working perfectly until I click on one month and the selected value goes to the end of the list. I don't understand why this behavior, considering in the proprieties I choose to sort by the expression MONTH_MONTH_OF_YEAR and not by state. Please, take a look at the enclosed document.
I believe that this is occurring because when you make a selection the other months are not selected. Therefore MONTH_MONTH_OF_YEAR is essentially NULL. If you change ascending to descending you see the selected values are now at the top. You could do either of the following:
- Sort by load order. This assumes that the months are loaded in the correct order.
- Load the Months as dual data types where the second parameter is the load order. Then they will sort correctly.