- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2022 10:43 PM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2022 11:29 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2022 10:57 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2022 11:01 PM
Hi,
where did you add new choice? did you ensure the choice value is number and label is text
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2022 11:39 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2022 11:45 PM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader