Dear friends,
In list and Search type I create a list with three filters - Article Title (text field), Category Filter (Checkbox Dynamic) and Producer (added in articles text field). Article Title and Producer wоrks OK, but when I try to filter my articles with Checkbox Dynamic ( table #__categories, options name: title, options value: id, where id IN ( Ids of my categories) ) I see no results.
My Checkbox Dynamic query works perfect and I see the names of my categories with check boxes in front of them, but when I click in some of this boxes to filter the articles the result is "There is no result" even if in the the choosen category have many articles.
Please, help me to solve this problem. Than you in advance for your collaboration.
Turn on debugging in search&list to see what values are used in query, then you can change matching to get desired result. Probably you have set wrong matching on the field as checkbox with multiple values resuts in an array of values, so you need to use Any words or Each word matchings