How can I limit an option created in a field to only that table's field?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-20-2023 04:08 AM
I have created a choice "Completed with help" in the State field on Story table but this choice is visible all over the ServiceNow platform wherever the State field is used. I only want the choice to appear in the state field of the Story Table.
How can I achieve this? Can anyone please help?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-20-2023 04:37 AM
How did you create the choice? The correct way is to right-click the State field label, then choose Configure Choices. Give the choice a label, value, and apply it to the Story table - click the Add button, then Save to return to the Story form.
The new State will only appear on the Story form drop-down, not Incident, Change,... everywhere else State is used.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-20-2023 04:44 AM
I created the choice by right clicking on the State field >> Configure Dictionary >> selected the Choices tab and created new choice with giving the label and name. Since then, that choice is appearing all over the platform wherever the State field is used.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-20-2023 10:52 AM - edited ‎11-20-2023 10:55 AM
Notice when you Configure Dictionary the field shows that it actually resides on the Task table, not rm_story.
Changing anything on the Dictionary Entry will affect EVERY appearance of the field. What you need to do in the case of making a field mandatory or read only, changing a reference qualifier (for reference or list fields), attributes, etc. is to create a Dictionary Override for that one specific table.
Creating the choice as I outlined is like creating a Dictionary Override for choice values, since it adds the choice(s) to the sys_choice table with rm_story as the Table, instead of Task - which also makes it available to all extended tables (story, change, incident,...).
I would recommend deleting the new choice record, then re-creating it the correct way. If you already have records using this value that you don't want to mess up, you can change the table field on the sys_choice table for this record to rm_story instead of task and it should accomplish the same.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-20-2023 05:08 AM
Go to sys_choice.LIST, then search for your choice value. Make sure table it selected as "rm_story" or whatver ou story table is. Then it will be visible under story table choices.
Regards,
Shamma