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

[Brad Bowman]

So when you used = the list only shows one value - the one you selected in the first dropdown?

[T Pappu]

Right. As I replied to Muhammad, I should reference the sysid and not the choice_name.

Thank you though for your response. 

KP

[MrMuhammad · Accepted solution]

I believe first drop down is reference field so it will return you sys_id and as Brad mentioned there should only be one selected value so we have either = oR !=. So, your RQ will be something like this.

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

[T Pappu]

Muhammad - You are right. Its the sys_id. When I replaced the choice_name with sys_id, it worked like a charm.

Thank you!

KP

[MrMuhammad]

Glad to be of Help 🙂

-Sharjeel