Incident subcategory field is not updating dynamically

[chennessy]

Geneva version, using Incident form, Category is selected.   Subcategory list does not update to the dependent category list unless the form is submitted/saved.     One other thing to mention is that the subcategory is a list field, not a choice field, so the user can select multiple subcategories.         Any suggestions are much appreciated!  

[Chuck Tomasi]

Thanks for the info Cheryl,

Rather than using depdency (which works great for choice list to choice list, or reference to reference) use a reference qualifier on the subcategory only as noted above. Somewhere in that subcategory reference table you need a category field to tie the two together. I'm going to assume you have a table something like this (adjust as necessary)-

Table: u_subcategory

Field u_name: string

Field u_value: string

Field u_category: string

javascript:'u_category=' + current.category;

http://wiki.servicenow.com/index.php?title=Reference_Qualifiers

[chennessy]

Well, there is no reference table.   The choices are just listed at the bottom of the field definition. Sounds like I should use a reference table instead.

Let me try that.

Thanks!

[Chuck Tomasi]

Yes, glide lists are meant to be used as a reference to a table.

[chennessy]

Thanks, Chuck, I set it up as a reference table and it worked, first try!       So glad to have this forum as I learn ServiceNow!

[arielgritti]

Hi @Chuck Tomasi 

I created a dependency between close_code and assignment_group on the incident table.

The close_code field is dependent on assignment_group. Works fine. My problem is, doesn't work in the same way that category/subcategory fields, doesn't refresh the values automatically.

When I changed the assignment_group the values on the close_code doesn't change. I need to save the record and then the values are changed.

In the category/subcategory fields when you change the category the subcategory field is cleared and the values change.

Any idea?

The only difference I saw is that assignment_group is a reference field and category is a choice field.

Thanks for your help

Ariel