help with complex attribute_filter

Wednesday 15 September 2004 3:09:17 am

hi all
i got to fetch some object of my class if:
attribute_322 = 0 AND (attribute_331 = current_user.login OR attribute_331 = 'all')

the attribute filter i use is:

attribute_filter, array(and,array(322,'=',0),array(or,array(331,'=',$current_user.contentobject.data_map.user_account.content.login),array(331,'=','all'))),

if i fetch the objects only by filtering the 331 attribute everything works, the problem arrives when i try to filter the 322 attribute too.

best regards
alessandro

Wednesday 15 September 2004 6:00:42 am

thanks paul!
i downloaded the patched file, but i never used the 'in' clause.
please, can you give me an example on how to translate the 'and' (/'or') clause in the 'in' one?

best regards
alessandro

Thursday 16 September 2004 1:01:12 am

hi paul
thanks for your replies
but i still am not able to get it work...
that's the code:

			{let memo=fetch( content, tree, hash( parent_node_id, 250,
									class_filter_type, "include",
									class_filter_array, array(42),
									depth, 10,
									attribute_filter, array(and,array(322,'=',0),array(331,'in',"('call','tutti')")),
									limit, 5,
									sort_by, array( published, false() )
									))}

and i don't retrieve any memo.
that's the sql output:

SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name

, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name

, ezcontentobject_attribute a1 , ezcontentobject_attribute a2

WHERE
path_string like '/1/2/250/%' and depth <= 12 and



a1.contentobject_id = ezcontentobject.id AND
a1.contentclassattribute_id = 322 AND
a1.version = ezcontentobject_name.content_version AND
a1.language_code = ezcontentobject_name.real_translation AND
a2.contentobject_id = ezcontentobject.id AND
a2.contentclassattribute_id = 331 AND
a2.version = ezcontentobject_name.content_version AND
a2.language_code = ezcontentobject_name.real_translation AND
( a1.sort_key_int = '0' AND a2.sort_key_string IN (\'call\',\'tutti\') ) AND
ezcontentclass.version=0 AND
node_id != 250 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND

( ezcontentobject.contentclass_id = '42' ) AND
ezcontentobject_tree.contentobject_is_published = 1
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
ezcontentobject_name.content_translation = 'ita-IT'
AND ((ezcontentobject.section_id in (1, 10, 11, 5, 8)) or (ezcontentobject.contentclass_id in (16) AND ezcontentobject.section_id in (2)) or (ezcontentobject.section_id in (10, 6, 8)) or (ezcontentobject.contentclass_id in (44) AND ezcontentobject.section_id in (5)))

ORDER BY ezcontentobject.published DESC
LIMIT 0, 5

the error i retrieve when i paste the query in the mysql client is:
Error: You have mismatched `'`

any hint?
thanks a lot
alessandro

Friday 17 September 2004 6:33:15 am

paul
i pasted your code in my tpl but the error i get is the same:

SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name

, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name

, ezcontentobject_attribute a1 , ezcontentobject_attribute a2

WHERE
path_string like '/1/2/250/%' and depth <= 12 and



a1.contentobject_id = ezcontentobject.id AND
a1.contentclassattribute_id = 322 AND
a1.version = ezcontentobject_name.content_version AND
a1.language_code = ezcontentobject_name.real_translation AND
a2.contentobject_id = ezcontentobject.id AND
a2.contentclassattribute_id = 331 AND
a2.version = ezcontentobject_name.content_version AND
a2.language_code = ezcontentobject_name.real_translation AND
( a1.sort_key_int = '0' AND a2.sort_key_string IN (\'call\',\'tutti\') ) AND
ezcontentclass.version=0 AND
node_id != 250 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND

( ezcontentobject.contentclass_id = '42' ) AND
ezcontentobject_tree.contentobject_is_published = 1
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
ezcontentobject_name.content_translation = 'ita-IT'
AND ((ezcontentobject.section_id in (1, 10, 11, 5, 8)) or (ezcontentobject.contentclass_id in (16) AND ezcontentobject.section_id in (2)) or (ezcontentobject.section_id in (10, 6, 8)) or (ezcontentobject.contentclass_id in (44) AND ezcontentobject.section_id in (5)))

ORDER BY ezcontentobject.published DESC
LIMIT 0, 5

Error: You have mismatched `'`

...
thanks for your patience..
best regards
alessandro

Friday 17 September 2004 7:07:06 am

Yes, must be a bug in 3.4.0 (or php settings?)

I tested it on 3.4.1 and 3.4.2 (from pubsvn) and it works here like intended.

I was thinking of making it easier, like the possibility to supply an array instead of a string, but too much time constraints now.

Don't you have other issues with 3.4.0 as well? Try hard to upgrade, lots of things have been fixed in the 3.4.2 branch on pubsvn

-paul

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans