How to exclude one value in a searchstring of the select field action of a button?

[cheburashka]

Hello,

I want to use the select field action in a button to select all the values of the field Classificatie except the value 'geen'.

I already tried following possibilities:

= '>geen<geen'
= '*' <> 'geen'
= '*' NOT 'geen'
= '*' ! 'geen'

Any suggestions?

_Koen

[Gysbert_Wassenaar]

Use two actions. The first is Select in Field with geen as search string. The second action is Select Excluded and will invert the selection. Note, this will not select values that are excluded by selections in other fields. If you need that you may have to clear other fields first.

You could also try this: ='(' & concat({<MyField -= {'geen'}>} distinct MyField, '|' ) & ')'. The expression editor doesn't like -= but that's a bug. But with that expression you need only one Select in Field action.

[cheburashka]

This solves my problem but aint there a more elegant way?