How to configure a parent-child dependency between variables on a record producer? - Support and Troubleshooting

How to configure a parent-child dependency between variables on a record producer? Issue .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } }  Description It is common to have dependent lookup fields which have a parent-child relationship, for example the category and subcategory fields of the incident table. The options presented in the subcategory field are dependent on what value the user selects into the category field.

In order to make variables work in same way it is necessary to configure the variables in a different way. Simply mapping the variables to the fields in the underlying table is not sufficient to use the choice dependency that might already be defined on the fields.

In the community there appears to be many postings that suggest the use of a custom script to programmatically populate the option items list of the child variable when the parent variable's value is changed eg. onChange catalog client scripts.

However, it is not necessary to use scripting in such a scenario, it is also possible to implement a solution using a declarative approach.

Procedure Use below steps to achieve similar parent-child behavior that is seen in incident form for the category and subcategory fields:

1. Create new record producer based on incident table.

2. Create variable (category) as below which indicates parent category: Question = category Map to field = true Field = category Type = Lookup Select Box Lookup form table = sys_choice Lookup value field = value Lookup label field(s) = label Reference Qualifier = javascript:'nameSTARTSWITHincident^elementSTARTSWITHcategory';

3. Create variable (Subcategory) as below which indicates child category: Question = subcategory Map to field = true Field = subcategory Type = Lookup Select Box Lookup form table = sys_choice Lookup value field = value Lookup label field(s) = label Reference Qualifier = javascript: 'element=subcategory^nameSTARTSWITHincident^dependent_value='+current.variables.category; Variable Attributes = ref_qual_elements=category

Applicable Versions All versions

Additional Information in case that instance has multi-language support plugins enabled it will be necessary to add additional condition on the reference qualifier. This is restrict the records displayed based on the user's current selected language.

eg. for category variable the reference qualifier should be

javascript:'nameSTARTSWITHincident^elementSTARTSWITHcategory^languageSTARTSWITH'+gs.getSession().getLanguage();

and for the subcategory variable the reference qualifier should be

javascript: 'element=subcategory^nameSTARTSWITHincident^dependent_value='+current.variables.category+'^languageSTARTSWITH'+gs.getSession().getLanguage();

Release .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } }

Resolution .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } }