[SOLVED] CB list bug contains filter is missing %

I want to filter a list based on a Check Box (Multiple) field. But then only returns results when one option is selected.

Example:
Field: cb_Options
Values:Option1,Option2
CB list Filter is set as: 'Options contains Option1'
Result
Only users that have only the Option1 showing up.
If they have both selected there are not shown.

Looking at the query i found the problem
((cb_Options LIKE 'Option1'))
should be
((cb_Options LIKE '%Option1%'))


_{How many post do i need for link rights?:silly:}

Userlists default to simple "is" searching, which is exact matching so it won't have wildcards. Change the userlist search behavior to simple "any" or advanced. Suggest downloading and reading through the CB Primer Book as it'll be of great help getting things initially configured.

www.joomlapolis.com/downloads/documents

Sorry but if you put a 'contains' option in the dropdown i expect that it works like a contains and not like 'equal to' which is also available in the drop down .

At the 'does not contain' option you do it correctly.
( ( `options` NOT LIKE '%option1%' OR `options` IS NULL ) )

Why not do add % for contains so that it is working as the option is suggesting instead that people have to find out that the contains is a dummy option that is not working?

Works perfectly fine in my tests. Under the Filters tab of my userlist the following have been tested.

Field: cb_checkbox
Operator: Contains
Value: Option1

Results in the following.


Field: cb_checkbox
Operator: Does not contain
Value: Option1

Results in the following.


Works fine combining the two as well.


Your instance of ((cb_Options LIKE 'Option1')) was probably due to a search on the userlist and not a filter. Searching the userlist with simple "is" search mode will result in no wildcards.

Your right after retesting i found out 2 flaws of my own. :pinch:

1. The filtering in my list was incorrect because i mixed up value and label, so it was correct that there was no result.
2. Because the list was not working as i expected i put on debug code and found that % was missing,.. but this was a select from my own listmodule that was shown on the same page. :blush: