Hello.
I am currently creating a multi-line variable set of catalog items.
There are five SelectBoxes in the multi-line variable set.
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.
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.
Does anyone know of a solution?
Thank you in advance for your help.
try giving value column here
If my response helped please mark it correct and close the thread so that it benefits future readers.
Thank you very much.
I changed the third variable Lookup value field to “Value” but it did not work as expected.
Out of curiosity, I also changed the second variable Lookup value field to “Value” and the third SelectBox(3階層目) displayed the choices.
However, it is no good, because the value is displayed, not the label, but....
@Koki Sugimori I tried replicating your requirement in PDI and it worked. Below is what I configured
MRVS --> Variable 1 --> Country --> Select Box
Choices for Country variable as below
MRVS --> Variable 2 --> States --> Lookup Select Box
Choices for Australia country as below. Here dependency value is Australia country. If you see below Value and label is different same as per your scenario.
MRVS --> Variable 3 --> City --> Lookup Select Box
Choices for city for dependency value as Victoria & Queensland. If you see below Value and label is different same as per your scenario.
Below is the screenshot of variable 2 and variable 3 configuration
Variable2 --> States
Variable 3 --> City
I am keeping Lookup field value as Label for state and city variable. I can see label in state and city variable instead of values.
Compare above screenshot with your variable and check.
If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!
Thank you very much.
As you can see in the image, I set Variable2(2階層目) and Variable3(3階層目), but nothing was displayed in Variable3(3階層目).
Variable2(2階層目)
Variable3(3階層目)
SelectBox→LookupSelectBox works, but LookupSelectBox→LookupSelectBox does not work.
Is there a problem somewhere in this?
Or is there a problem with the records in the sys_choice table?
