Select all fields except one using searchs

[polisetti]

I have a listbox having values: A,B,C,D,E etc

now in the search option can I search values as "All values excpet C". Basically client wants to select all values except one value. Is it possible.

Regards

[flipside]

Easiest way is to select the value you don't want, then Select Excluded (via right click) to "reverse" the selection.

[sudeepkm]

you can create another field based on your existing field (say FeildName is your existing field) in your load Script which will have logic like below.

if(FieldName='C','NA','All') as FieldSelect

Then you can use this new field FieldSelect in the Search Object. So that when Clients will select All then it will select all except C.

[marcus_sommer]

Listbox search operator for "unequal"

[#5 · Accepted solution]

Hello,

Have you tried with the sign "-" before the value you want to exclude ?

For example, -C to select all values except C.

Regards,

Nicolas