A choice value in a table is showing the value instead of the Label, just one choice from the list

[Daniel Rodrigue]

I have a choice list in table alm_hardware and when creating a new record, sometimes it shows a value (which is an integer) instead of the Label for a particular choice, and sometimes the same Choice does not show up at all. I have tried to create the to create the choice by going to:

System Definition > Tables > Filter the alm_harware table, then look for the choice field, and finally add the new choice list. But the issue is still happening. In Top domain

[Bhavya11 · Accepted solution]

Hi @Daniel Rodrigue 

i have gone through the similar issue but i found out two things one is 
1. There is not a display field set on this table.  

2. choice value length is more the max length so at that time it was showing this issue

please refer the below link

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0696128

Please check it and let me know if you find it. Mark it as helpful if it helped you.

Thanks,

BK

[Daniel Rodrigue]

Hi @Bhavya11,

Thanks for your reply, your answer somehow helped to solve the issue in my environment.

The issue was related to not having the state Choice associated to the table alm_hardware, we only had the Choice value associated to the main table alm_asset, but we needed on both, because alm_harware is an extension of alm_asset. 

Thanks and

Best regards!