How to show and remove options in List Collector variable catalog item

Shalika · ‎11-27-2022

I have a catalog item with variable as List collector named "Location" and another variable "Selection of needed areas" which is also List collector. Both the variables are referencing to the same table as shown

The location field has values Singapore and Porvoo. The "Selection of needed areas" field has 4 values p1,p2,p3 and p4. I want that if a user selects Singapore location then the 1st 3 values p1,p2,p3 should display and if Porvoo is selected p4 should display. How can I do this?

Murthy Ch · ‎11-27-2022

Hi @Shalika

You can try below logic in reference qualifier:

javascript&colon;
var arr=[];
if(current.variables.u_location.indexOf("Singapore sys_id")>-1)
{
arr.push("p1 sys_id","p2 sys_id","p3 sys_id");
}
if(current.variables.u_location.indexOf("Porvoo sys_id")>-1)
{
arr.push("p4 sys_id");
}
"sys_idIN"+arr.toString();
// replace with your variable names and sys_id's

Hope it helps.

Thanks,
Murthy

View solution in original post