Populate List collector catalog item variable on the basis on another variable

[vivek72]

Hi,

I have below requirement,

Catalog item A contains 2 variables A1 and A2.

A1 is of type Lookup select box referring to table B.

Table B has 2 columns B1 and B2.

Values from B1 should be shown in Variable A1 and it's working fine also with the help of Look Up field value which is set to column B1.

Now requirement is that variable A2 which is of List collector Type should show values from B2 where A1 and B1 are same. Problem here is that in List collector type field we do not have an option to give look up field name and  I am not able to specify that it should show values from B2.

Please suggest how A2 will show values from B2, right now it's showing duplicate values from B1, but not unique values from B2 when A1 and B1 are matching.

[AshishKM]

Hi @vivek72 , 

Did you try to apply some Ref qual.

-Thanks,

AshishKM

[vivek72]

Hi @AshishKM ,

Yes, but every time it shows values from B1 and not showing values from B2

If I select Lookup select box and specify look up field as B2, then it works fine.

But since we need multi select option, we need to use list collector and with this type we do not have any option to specify look up field.

[AshishKM]

In that table (B) , column B1 must be configured as "Display Value = true"

let me know if you wanna connect and we can review together. Inbox the link for call.

[vivek72]

Yes, you are correct!

for B1, Display checkbox is checked but for B2, it's unchecked.

What should we do now to make it work and display values from B2?

Do we need a client script and Script include logic to make it work as per my use case or is there any other way to make it work with just a reference qualifier ?