Forums / Setup & design / Is there any limitation in fetch list attribute_filter?

Is there any limitation in fetch list attribute_filter?

Author Message

Alex Brie

Thursday 01 February 2007 8:30:34 am

Sorry I won't probably make sense explaining my problem:

I am trying to create a form with 6 html lists where I select several attributes to filter by. The form is sending 6 parameters to a custom search, where I want to display my objects , filtering them by the values of 6 attributes.
All in all,

{def $combined2=fetch( 'content', 'list', hash( 'parent_node_id',   1539, 'attribute_filter',   array( 'AND', $query_site, $query_sitegr, $query_subject ,$query_subjectgr,  $query_countr, $query_countrgr)) )}

where the values of the queries look like

{def $query_subjectgr =  array( 'ee_article_linear/groupe_sujet', '>', '0')}

My PROBLEM is:
this DOESN'T work if I have <b>all the 6 criteria.</b> However, if I have <b>only 4</b> it works.

Is there some limitation inside the fetch function or inside the attribute filter, that prevents the full query to work?

Please help, I'm past behind my project deadline and this bug is keeping me stuck for a week now..

stephane couzinier

Thursday 01 February 2007 3:57:53 pm

I make fetch with more filter.
did you activate the debug mode, if there is an error on the query you will see it.

don't flush the cache

Bruce Morrison

Thursday 01 February 2007 7:14:06 pm

Hi Alex

You might want to check that the attribute filters are all for the same content type.

Cheers
Bruce

My Blog: http://www.stuffandcontent.com/
Follow me on twitter: http://twitter.com/brucemorrison
Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish

Alex Brie

Friday 02 February 2007 1:13:23 am

I've checked it over and over again: all subqueries are correct, all the attributes are of exactly the same type. My class has a title, body, and 6 object_relation fields (the ones I make the filtering by). So there's no difference between the fields..

As for the Debug SQL - I tried it, but it shows me A LOT of queries, none of which even close to the query I make...