Are choice values case-sensitive?

[Nen]

Hi! We have a custom table with the following states:

We decided to make them more "standard" so we edited the values of the choices and set them to their lowercase equivalents. If we deploy the changes to Prod, will the records with "CANCELLED" and "CLOSED_COMPLETE" states be tagged as "cancelled" and "closed_complete"?

[Jaspal Singh]

Hy Nyreen,

There exists 2 things. Choice value & Label. If required, you can modify the Label but better not to update the choice value.

[Gaurav Shirsat]

Hi Nyreen

you could have a choice with label "SAP" and value "sap". Though if you would have a UI Message [sys_ui_message table] with a record that has key and message "sap", this will overwrite your label from your choice. This also happens even if your label is first letter uppercase and your UI Message key is all lowercase. Then still, the UI Message will overwrite your label from your choice.

You could also check the  sys_cb_design_topic table, open your topic, and search in the Design definition field for:

[{"type":"Choice","choices":[

Within there, the choices should be visible. For example:

{"name":"Test","element":"test"}

Could you also check if there's a UI Message record for "sap"? It could be, that both the key and message for this is "sap".

Please Mark Correct and Helpful

Thanks and Regards

Gaurav Shirsat