Alphabetize Custom Field values

Added by Chris Martin over 10 years ago

Hey everyone,

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:

Original List

  1. Green
  2. Red
  3. Yellow

Added in 'Blue'

  1. Blue
  2. Green
  3. Red
  4. Yellow

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).