New state values are not coming. Please help me on this.

Bhargavi K
Kilo Contributor

Hi all,

Please help me on this. I have one custom table which is extended from the task table, in my custom table state is there which is coming from Task table. I need to display new state values for this. For this, I went to dictionary entry of state in custom table and I have created new choices and I have given custom table in creating of each choice of state but here my new state values are not came instead of this numbers are coming. 

find_real_file.png

1 ACCEPTED SOLUTION

Mahendra RC
Mega Sage

Hello,

I believe these are the existing record in your custom table which are having the state value which were extended from Task table. So know when you have created new State for your custom table with different state values and these old states are now not applicable now.

So if you create any new record in your custom table you should be able to see the new states that you have created for your custom table and these records you have shown are old record. So if you want to correct these state value to have to update those manually or via script.

Please mark this as helpful/correct, if it answer your question.

Thanks

View solution in original post

8 REPLIES 8

Sagar Pagar
Tera Patron

Hi,

As per my understanding, the choices are not available in sys_choice table. hence it is showing the back-end values as (3), (1).

You can check teh Choices [sys_choice] table and apply filter conditions. Make sure you have created/ added choices for your custom table.

 

Thanks,

Sagar Pagar

The world works with ServiceNow

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

where did you add new choice? did you ensure the choice value is number and label is text

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi Ankur,

I added new choice in the state of task table which is in custom table, but I created the value as text and label is also text, so that's why it is showing like that I believe. Now, I have changed the value with number it's working.

Thanks & Regards,

Bhargavi.

Hi,

Did you check for new records?

Seems for existing records the values are incorrect possibly because some script/data load was trying to set value which doesn't exist.

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader