How to set dependencies in a multi-line variable set (catalog item) selection box

Koki Sugimori
Tera Contributor

Hello.

 

I am currently creating a multi-line variable set of catalog items.
There are five SelectBoxes in the multi-line variable set.

KokiSugimori_0-1744952136581.png

 

Since we want to display the choices from the second SelectBox(2階層目) in such a way that they have a dependency, we have configured the settings as follows.

KokiSugimori_1-1744952438557.png

KokiSugimori_2-1744952447730.png

 

Here is where I am having problems.
I set the Reference qualifier in the third SelectBox(3階層目) as well as the second SelectBox(2階層目), but when I check from the Portal, the choices are not displayed.

 

I further checked and found that in the SelectBox(1階層目) -> Lookup SelectBox(2階層目), the dependency (Reference qualifier) works correctly and the choices are displayed, but in the Lookup SelectBox(2階層目) -> Lookup SelectBox(3階層目), not even the choices with the dependency are displayed.

 

KokiSugimori_3-1744953228015.png

KokiSugimori_4-1744953235388.png


Does anyone know of a solution?

 

Thank you in advance for your help.

20 REPLIES 20

@Ankur Bawiskar 

It doesn't work even in admins.

 

So it sounds like there is a problem with other fields in the sys_choice table (other than language) or variable settings (Reference qualifier, etc.).

@Koki Sugimori 

yes it's something else and not related to language or ref qualifier as the same logic has worked for other member

it's something to do with the u_test_choice field

your variables are in global scope but u_test_choice field is in which scope
if it's in CSM scope then it's a cross scope issue

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Ankur Bawiskar 

From the following image, I believe the u_test_choice field is in the global scope.

KokiSugimori_2-1745299318373.png

KokiSugimori_0-1745299272199.png


Regarding the cross-scope issue, as a verification work, PDI created a u_test_choice(1~5) field in the sc_req_item table.
Therefore, the scope is in global scope, so even though there is no cross-scope issue, the choices are not displayed.

@Koki Sugimori 

it's strange that the dependency works for variable2 but not for variable3

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Ankur Bawiskar 

I too have my doubts about it not functioning properly.

 

One thought, I have imported about 580 records into the sys_choice table this time.
Compared to when you guys were verifying with PDI, etc., the total number of choices is quite different, and I wonder if that is what is causing some error in the dependencies...