How to filter the Lookup Select Box values based on the Select Box values?

[Sudesh]

In catalog item, i had two variables with type Lookup Select Box & Select Box

i had variable type Select Box with two choices like automation & nonautomation.

Based on the selection of the choice , the Lookup Select Box values should filter the values in the table (location table)

There are no Reference values between the two variables

[SaiVasanth]

Hi @Sudesh ,

What are the conditions that means if you selected automation then what values do you need to show in lookup select box as well as for the nonautomation what values do you need to see from location table (cmn_location)

Thanks

[Sudesh]

The location table need to filtered based on state ,Ex:-when automation is selected, need to dispaly  location only having state as 'TX' only, when non automation is selected,need to dispaly  location only having state as 'GA' only,

[Rahul Talreja]

Hi @Sudesh ,
Can you please describe some use case so we can be clear about using which type of reference qualifier?
Most probably, what I can see is you will need a advance reference qualifier and need to write a script include to return the filtered value of cmn_location table.

[Sudesh]

Hi @Rahul

The location table need to filtered based on state ,Ex:-when automation is selected, need to dispaly  location only having state as 'TX' only, when non automation is selected,need to dispaly  location only having state as 'GA' only,