Reference Qualifiers - Using Operators (STARTSWITH, NOT LIKE)

[T Pappu]

Hello,

I have a first dropdown field (field type - 'Reference') with 5 values which has A, B, C, D, and E.

I have the second dropdown (field type - 'List'). I need to populate the list collector with all values except what is selected in the first dropdown. So if I select A in the first dropdown, then my second dropdown (list collector) should display B, C, D, and E so the users can choose multi-select from these values.

This needs to work for the service portal.

I tried creating an advanced reference qualifier for the second dropdown where I have this query in the Reference Qual - 

javascript:'choice_nameNOTLIKE'+current.first_dropdown;

The above code does not work. If I replace the 'NOT LIKE' with '=' it works. It tried with other operators like 'STARTSWITH' and it doesn't work. It populates all the values.

I am checking if anyone has an idea of how to accomplish this using reference qualifier.

Thanks,

KP

[Ashutosh Munot1]

HI,

javascript:'choice_nameNOTLIKE'+current.variables.first_dropdown;

Thanks,
Ashutosh

[Brad Bowman]

Since first_dropdown is only one value, your list reference qualifier will either be = or !=.

javascript:'choice_name!='+current.first_dropdown;

[johnfeist]

Hi KP,

If using = works, I assume that only gives you one value, have you tried using != instead of NOT LIKE?  In many cases, especially when the value you are comparing to is very short, the absolute comparison is more reliable than the fuzzier Like, NOT LIKE, etc.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

[T Pappu]

Thanks all.

Ashutosh - I am not using record producer so I believe I cannot use the .variables

Brad/John - I used != and it still populates all the values.