Hello
I'm not far of the success...
Actually when I switch the backend in english, value filters can be combined. I selected "all", and... I have a SQL error message in my frontend when I do a search.
here is the message :
getData(): SQL QUERY ERROR:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ANDvalue='wifi') ) GROUP BY i.id ORDER BY rel.catid, rel.ordering ASC, i.title ' at line 1 SQL=SELECT SQL_CALC_FOUND_ROWS i.id FROM bl9ye_content AS i JOIN bl9ye_flexicontent_items_ext AS ie ON ie.item_id = i.id JOIN bl9ye_flexicontent_types AS ty ON ie.type_id = ty.id JOIN bl9ye_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id JOIN bl9ye_categories AS c ON c.id = i.catid LEFT JOIN bl9ye_users AS u ON u.id = i.created_by WHERE 1 AND rel.catid IN ('8') AND ( i.state IN (1, -5) OR ( i.created_by = 0 AND i.created_by != 0 ) ) AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0 AND i.created_by != 0 ) ) AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0 AND i.created_by != 0 ) ) AND ( ie.language LIKE 'fr%' OR ie.language="*" ) AND ty.access IN (0,1,1) AND c.access IN (0,1,1) AND i.access IN (0,1,1) AND i.id IN (SELECT DISTINCT item_id FROM bl9ye_flexicontent_fields_item_relations as rel WHERE rel.field_id = 34 AND (value='1') ) AND i.id IN (SELECT DISTINCT item_id FROM bl9ye_flexicontent_fields_item_relations as rel WHERE rel.field_id = 15 AND (value='Ain') ) AND i.id IN (SELECT DISTINCT item_id FROM bl9ye_flexicontent_fields_item_relations as rel WHERE rel.field_id = 28 AND (value='piscine_exterieure'ANDvalue='wifi') ) GROUP BY i.id ORDER BY rel.catid, rel.ordering ASC, i.title LIMIT 0, 10
getAlphaindex(): SQL QUERY ERROR:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ANDvalue='wifi') ) ORDER BY alpha ASC' at line 1 SQL=SELECT DISTINCT LOWER(SUBSTRING(i.title FROM 1 FOR 1)) AS alpha FROM bl9ye_content AS i JOIN bl9ye_flexicontent_items_ext AS ie ON ie.item_id = i.id JOIN bl9ye_flexicontent_types AS ty ON ie.type_id = ty.id JOIN bl9ye_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id JOIN bl9ye_categories AS c ON c.id = i.catid LEFT JOIN bl9ye_users AS u ON u.id = i.created_by WHERE 1 AND rel.catid IN ('8') AND ( i.state IN (1, -5) OR ( i.created_by = 0 AND i.created_by != 0 ) ) AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0 AND i.created_by != 0 ) ) AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0 AND i.created_by != 0 ) ) AND ( ie.language LIKE 'fr%' OR ie.language="*" ) AND ty.access IN (0,1,1) AND c.access IN (0,1,1) AND i.access IN (0,1,1) AND i.id IN (SELECT DISTINCT item_id FROM bl9ye_flexicontent_fields_item_relations as rel WHERE rel.field_id = 34 AND (value='1') ) AND i.id IN (SELECT DISTINCT item_id FROM bl9ye_flexicontent_fields_item_relations as rel WHERE rel.field_id = 15 AND (value='Ain') ) AND i.id IN (SELECT DISTINCT item_id FROM bl9ye_flexicontent_fields_item_relations as rel WHERE rel.field_id = 28 AND (value='piscine_exterieure'ANDvalue='wifi') ) ORDER BY alpha ASC
For me it is just chinese...
my field is a checkbox