[Load jQuery once] Tab ne s'affichent pas

Hello

-- the combination among Filters is always -AND- (aka ALL required)

-- the combination between the filter values of single filter is configurable

(e.g. a single filter can be multi-valued if you have configured it to appear as checkboxes OR as tag-like selection)

and you can set the parameter "Values combination" inside the configuration of every field

Hello
I actually have an option "values combinaison" in my checkbox field configuration (in Content Lists views / Search view Filter Configuration parameters). But I have the choice between "Tout (all)" or "Tout (all)"... The one or the other, in frontend, it doesn't displays with "AND"...
Or maybe I have to choice something in "Value Comparison"... I have the choice between "alphanumerique", "integrer" or "float"...

Hello

translation is wrong, switch your backend language with english to confim this

about parameters please read popup description,

Value Comparison
-- important (used) when filter is displayed as (appears as) range

Values combination
-- used when filter is displayed as (appears as) checkboxes or tag-like selection
... these all multiple values to be selected

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

Hello

this is a bug when enabling (for a field filter):
value combination to require "ALL" instead of "ANY" value

-- to apply a quick fix , edit file:
components/com_flexicontent/classes/flexicontent.fields.php

find line: and replace with

Hello !

Ok that's good now : the search is loading, but no result appears (I have the message : no result found (...).
However, I tested with a value combinaison I'm sure an item exists...
www.facilidogs.fr/index.php/campings?filter_34 []=1&filter_15[]=Ain&filter_28[3]=wifi&filter_28[4]=aire_jeux

Hello

yes,
indeed i looked at it,
and its not implemented properly,

please disable this setting "value combination" (it is a new feature) we will try to fix in next release

OK,
thanks for your help
I'll wait the next release

Hello

thanks for report i have already made a fix , whose effectiveness and speed will be tested soon

thanks for reporting

Regards

Hello ggppdk,

I have the same problem about no result with ALL selected for value combination, could you tell me if the fix is included in the last version FLEXIContent - 2.1.2 - r1806 -- [for Joomla 2.5 - 3.2] RC Featured?

Thank you