CWM custom column choice and punctuation

[Jonathan F]

TLDR: unless/until ServiceNow starts supporting punctuation as options when creating custom choice columns in CWM, avoid including punctuation. OR, you can probably use punctuation if you modify the entry in the sn_cwm_col_choice table after first creating without the punctuation. (I haven't tested it)

I created a custom column for my CWM board, and thought it would be amusing to have one of the choices be "Wait, What?" Unfortunately, the punctuation has broken the ability to filter by that value.

I can see that this custom choice is added to the sn_cwm_col_choice table, and it had the label of "Wait, What?", but also the value of "wait,_what?", and that value is likely causing issues in the filtering code.

Unfortunately, simply removing the punctuation from the value did not resolve my issue, so this must be persisted in other locations I have not yet found.

[Sunil B N]

Hi Jonathan,
Thanks for bringing this to our notice. Definitely an interesting use case. While we will address issue in the future release, can you try deleting the column and re-creating it. (Hoping that you don't have any column data yet). 

While creating the column - give a name without punctuation as you said, and later you can go ahead only change the label in sn_cwm_col_choice. This must be done before you update any tasks in the board.

In specific to your use case, filtering may not be working as tasks column data would be still pointing older choice internal name. Also we save filters into preference and so on which will affect the data shown.

Let me know if this helps. Thanks again for shedding light on the use case.
Best Regards,
Sunil B N