Alphabetize Custom Field values
I have a custom field that's a list of text values. I'd like to be able to maintain this list alphabetically. In the past I've tried to manually alphabetize the list, but then i found that would mess with the value assignments. For example:
Added in 'Blue'¶
But then any tickets that were assigned "Green" are now "Blue", and with "Red" are now "Green", etc.
Is there a way to get this to work? Not sure if the best solution here would be a sort asc/desc flag, or manually hack up the db (if that's even possible).