in what table are incident sub categories stored

[johnfeist]

I'm still quite new with ServiceNow so apologies in advance for my ignorance.

We're setting up Incidents.   We need to categorize at three levels.   I think the way to do it is to set up a user defined table that extends from sub categories the way that sub categories extends from categories.   With a little trial and error I'll be able to do most of it.   What I'm not able to find is where are the sub categories stored.   Can anybody enlighten me?

TIA.

John

[Raghu Loganatha]

John,

Choice list values are stored in sys_choice table. You can access this by typing sys_choice and hitting enter in your left nav. Or you can access from the below linkhttps://<Instance Name>.service-now.com/sys_choice_list.do?sysparm_query=name%3Dincident . just change the instance name to yours.

~Raghu.

[Mike Allen · Accepted solution]

They are all in sys_choice, using the concept of dependent fields.   So, your subcategory choices have the dependent value of the category value.   To add a third level, just add the field, make it dependent in the dictionary on subcategory, and set up your values with the dependent value of the subcategory under which you'd like it to display.

[johnfeist]

Thanks Mike.   This looks to be just what I need.   I've set up a subsub category in Incident.   When I go into Dictionary, the only place I find Dependent Field is in the advanced view tabs but I can't enter anything.   What am I missing?

[Raghu Loganatha]

John,

Filter choice list by sub_category and on the value where you want to add dependent value . The dependent value field is a strong field where you have to get the category field value.  

Let's say if you want to make Subcategory Business Application as dependent on category Software.Dependent value will be 'software' for 'business_application'.

Sent from Yahoo Mail for iPhone