CB list, search on Multiselect field

Hi All

I have a field that is created as a Multiselect field, commaseperated.
I want to create a list that searches for a specific entry in this list, but which parameter should I use? Or should I use advanced, and how do I create that filter?
Btw. I found some old posts saying that I had to put % around the text I want to search for, that didn't change anything.

Nobody knows? Or it's impossible?

Multiselect fields are not comma separated in the database.

You need to use advanced filter to filter specific values.

I remember many forum post responses giving examples.

And as far as I can see I've been through most of them without any luck.
Most of them are about CB1.2, so I guess there could be a difference, so I'm a bit lost on this...

What is the name of your cb multiselect field?
What are allowable values of this field?
What is the value you would like to filter off?

The field is called 'cb_certificationlevel' Title of the field is 'Certifikatnavn'.
The values I've given are:
Intet
Open Water Diver
Adventure Diver
Nitrox
Advanced Open Water Diver
Emergency First Responder
Rescue Diver
Master Scuba Diver
Divemaster
Assistant Instructor
Open Water Scuba Instructor
Master Scuba Diver Trainer
IDC Staff Instructor
Master Instructor
CMAS *
CMAS **
CMAS ***
CMAS Instructor

I would like to make a cople of lists that contains people that have specific fields set.

One list 'Nitrox'
Another list
'Open Water Suba Instructor' OR 'IDC Staff Instructor' OR 'Master Instructor' OR 'CMAS Instructor'

Hmm, while writing this I just thought of testing with the field name instead of the title that the simple query uses.
And now it works, arh darned, sorry.

So the 'Advanced' query that looks like

FIELDTITLE = '%VALUE%' works.

and the query with FIELDNAME is wrong, and won't work in 'Advanced'.

The OR query is still wrong though:
'cb_certificationlevel' LIKE '%Open Water Suba Instructor%' OR 'cb_certificationlevel' LIKE '%IDC Staff Instructor%' OR 'cb_certificationlevel' LIKE '%Master Instructor%' OR 'cb_certificationlevel' LIKE '%CMAS Instructor%'