Hi,
I am using J 2.5.14 and FC 2.1.0 r1778
I have a checkbox field with ID 18 the values are from 1 to 5.
I want to display a list of all contacts with the field 18 checked.
I tried a menu link with permanent filter override here are the results
18##1 %% All contacts with value 1 are displayed
18##1---5 %% nothing is filtered all contacts are displayed
18##1+++2+++3+++4+++5 %% all contacts with value 1 are displayed
18##2+++3+++4+++5 %% all contacts with value 2 are displayed
18##3+++4+++5 %% all contacts with value 3 are displayed
etc
When I try with the universal module only the range is not working, multiple values is OK.
For the range I get this error:
Code:
getItems(): SQL QUERY ERROR:
Unknown column 'rel18' in 'where clause' SQL=SELECT i.id FROM hcvas_content AS i JOIN hcvas_flexicontent_items_ext AS ie on ie.item_id = i.id JOIN hcvas_flexicontent_types AS ty on ie.type_id = ty.id JOIN hcvas_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id JOIN hcvas_categories AS c ON c.id = rel.catid JOIN hcvas_categories AS mc ON mc.id = i.catid LEFT JOIN hcvas_flexicontent_fields_item_relations AS f ON f.item_id = i.id AND f.field_id=28 JOIN hcvas_flexicontent_fields_item_relations AS rel18 ON rel18.item_id=i.id AND rel18.field_id = 18 WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2013-10-01 08:01:53' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2013-10-01 08:01:53' ) AND ty.access IN (0,1,1) AND mc.access IN (0,1,1) AND i.access IN (0,1,1) AND i.state IN ( 1, -5 ) AND c.id IN (13) AND ie.type_id IN (2) AND (rel18 >=1) AND (rel18 <=5) GROUP BY i.id ORDER BY f.value ASC, i.title LIMIT 0, 20
Any idea?
www.belesco.be/about-belesco/board-of-directors
