Display value in ListCollector based of multipe conditions

sanvi
Tera Expert

Hi All,

I have a list collector variable on form for which look up table is say 'internal table'.

The variable should display values based on below conditions.

1) If requester is part of VIP department then ------> display all the device from 'Internal table' which has 'availablility' -- 'available', 'not available','both'.

2) If requester is not part of VIP department then ----> display only devices which has availability ---- 'available', 'both'.

 

i have configured the below condition for 2nd part but i am not sure how to include the first condition.

javascript: 'availability=both^ORavailability=available^u_status=active^' + "u_brand="+current.variables.preferred_brand;

 

Can anyone suggest how to filter data using both of the conditions 1 and 2.

10 REPLIES 10

Hi @Sonam_Tiwari ,

Yes the list is pointing to custom table.

I mean the type of variable is 'Look up select box' and the look up from table is the 'Custom table'.