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...

eZ debug

Timing: Jan 18 2025 10:55:53
Script start
Timing: Jan 18 2025 10:55:53
Module start 'content'
Timing: Jan 18 2025 10:55:53
Module end 'content'
Timing: Jan 18 2025 10:55:53
Script end

Main resources:

Total runtime0.2443 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0078 587.9531180.8125
Module start 'content' 0.00780.0064 768.765698.0703
Module end 'content' 0.01410.2300 866.8359527.3750
Script end 0.2442  1,394.2109 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00341.4080200.0002
Check MTime0.00140.5867200.0001
Mysql Total
Database connection0.00140.560510.0014
Mysqli_queries0.180974.06871410.0013
Looping result0.00170.69381390.0000
Template Total0.229894.110.2298
Template load0.00070.301310.0007
Template processing0.229093.761410.2290
Override
Cache load0.00050.203410.0005
Sytem overhead
Fetch class attribute can translate value0.00110.461810.0011
XML
Image XML parsing0.00030.118310.0003
General
dbfile0.00793.2315200.0004
String conversion0.00000.003230.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs