Cumulative Filter and Conditions?

[tsarma]

Applying conditions to Cumulative Filter throws Fatal error:
Contao 3.5.4
Isotope 2.3.1 b 4

Where 'var_check' is a custom attribute of type checkbox and applied to some T-shirts (Demo Installation)

Fatal error: Uncaught exception Exception with message Query error: Unknown column 'tl_iso_product.var_check' in 'where clause' (SELECT DISTINCT p1.colour AS options FROM tl_iso_product p1 LEFT OUTER JOIN tl_iso_product p2 ON p1.pid=p2.id WHERE p1.language='' AND p1.colour!='' AND p1.published='1' AND (p1.start='' OR p1.start<'1448629860') AND (p1.stop='' OR p1.stop>'1448629920') AND ( p1.pid=0 OR ( p2.published='1' AND (p2.start='' OR p2.start<'1448629860') AND (p2.stop='' OR p2.stop>'1448629920') ) ) AND ( p1.id IN ( SELECT pid FROM tl_iso_product_category WHERE page_id IN (87) ) OR p1.pid IN ( SELECT pid FROM tl_iso_product_category WHERE page_id IN (87) ) ) AND ( p2.type IN (2) ) AND tl_iso_product.var_check=1) thrown in system/modules/core/library/Contao/Database/Statement.php on line 295

[aschempp]

Your query must be invalid… maybe the field var_check does not exist? Or maybe the tables are not called tl_iso_product in the cumulative filter. Did you try to read the code?

[tsarma]

The attribute field var_check is defined and even some products (T-shirts) has its value set to 1.

maybe the tables are not called tl_iso_product in the cumulative filter

Products are stored in table tl_iso_product and var_check is a field of tl_iso_product. It is my aim to list only those product with the field var_check =1. Also the hint below Conditions field say :

Here you can enter a SQL condition to filter the products. You must prefix the fields with "tl_iso_product." (e.g. tl_iso_product.featured=1, tl_iso_product.color!='red')

[Toflar]

It should be p1.var_check instead of tl_iso_product.var_check. Checkout how the query is built.

[aschempp]

It should be p1.var_check instead of tl_iso_product.var_check. Checkout how the query is built.

That's probably a bug as we've changed this to the real table name a while ago. Looks like it was not changed in the cumulative filter.

[tsarma]

It still don't works as expected.
With this setting, filter don't throws error but it doesn't filters at all!

With this setting, it throws error

Fatal error: Uncaught exception Exception with message Query error: Unknown column 'p1.var_check' in 'where clause' (SELECT tl_iso_product.*, 'de' AS language, IF(tl_iso_product.pid>0, parent.type, tl_iso_product.type) AS type, IFNULL(translation.name, tl_iso_product.name) AS name, IFNULL(translation.teaser, tl_iso_product.teaser) AS teaser, IFNULL(translation.description, tl_iso_product.description) AS description, IFNULL(translation.meta

[aschempp]

so I wonder if we can change the table name? because that would break existing filter… ?

@tsarma maybe you need to use HAVING?

[SGehle]

Is there a solution for this problem? Still not working...

[aschempp]

The issue is assigned to version 3, and there is currently no work being done on a new major version.