Catalog List Modul - Condition

[quto]

Hi,

I want filter my catalog list by multiple ID's

I know how I filter by one Item

product_category=2

But how I can Filter bei multiple Items ?

product_category=2,3,4

I want just get the categorys with the ID's 2, 3 and 4 but by this way I get a error.

thanks

[Ben]

Where are you putting the code that you're talking about? Is this in the Condition field of the listing module where you enter sql? Maybe you're trying to do this in the url. If so, I believe you can only display multiple categories for tag fields, so it doesn't work for select fields. With mod_rewrite, the syntax is: http://domain.com/pageName/field/option-1,option-2.html.

You may also be interested in this extension to combine tag fields: http://www.contao.org/extension-list/vi ... 03.en.html

[thyon]

SQL cannot support a query like that, you have to use FIND_IN_SET() -- please read the tutorial as this is covered in that.