It looks like you're new here. If you want to get involved, click one of these buttons!
Still here, loving Fuel CMS !
I am trying to make a small change in filters, but can not get things to work the way I would like to.
I have a brand and country filter, and i would like for the select to be: where (country in ("",$this->filters['country']) and brand in ("",$this->filters['brand']))
so that I get all the entries where country is either the one I selected or empty and brand is either the one i selected or empty.
I am able to make the correct where statement, but by default, the parent list_items will add :
AND (LOWER(country) LIKE "%country%" OR LOWER(brand) LIKE "%brand%")
How can i prevent the parent from adding another where clause ?
You can try something like the following within your list_items method:
I'll try that, thanks a lot !