[SOLVED] Filtering Checkbox Multiple Field - Create a CB List

Hello,

I try to filter a CB List using a multiple checkbox and I want to test if one of two possible values are found combined with OR (not with and).

If I create two lines, each with one condition, the list has 0 users, even if there are user which fullfill one of the conditions.

I have not found a possibility to combine the two values connected with OR.

I hope it is understandable what the problem is.

Userlist filters are always AND. To filter against a multicheckbox or muliselect field having at least 1 of the supplied values you have to use REGEXP. Example as follows.

FIELD_NAME Is REGEXP /value_1|value_2/

Separate multiple values with |. If you need to filter by 1 field OR by another field you'll need to use Advanced mode and supply your own SQL that'll be added to the WHERE statement of the query.

I do not know much about the syntax of SQL I suppose thats my problem here.

At last I tried this "('cb_suche' LIKE 'suche')" in the advanced mode as both values contains the string suche but that did not work.

I found some examples here in the forum but none of it worked for my purpose.

I also tried things like "(('cb_suche' = 'Bandsuche') OR ('cb_suche' = 'Musikersuche'))".

I think it is a problem with the syntax I used.

Should your suggested Expression FIELD_NAME Is REGEXP /value_1|value_2/ in my case be 'cb_suche' = /'Bandsuche'|'Musikersuche'/?

Should your suggested Expression FIELD_NAME Is REGEXP /value_1|value_2/ in my case be 'cb_suche' = /'Bandsuche'|'Musikersuche'/?

See my above example. If using a Basic filter to match 1 of 2 values in a multicheckbox you'd use the below usage.

FIELD_NAME Is REGEXP /value_1|value_2/

If your fields values are Bandsuche and Musikersuche then you'd use the below.

FIELD_NAME Is REGEXP /Bandsuche|Musikersuche/

I tried this

cb_suche Is REGEXP /Bandsuche|Musikersuche/

in advabced mode and became an error "Fehler: 1064"

What is wrong now?

P.S.: cb_suche is the name of the field with the multiple checkpox.

The filter I've provided is for Basic mode. Advanced you need to supply completely valid SQL statements.