Forums / Developer / Help with fetch please.

Help with fetch please.

Author Message

Jorge estévez

Sunday 05 October 2008 7:12:01 pm

Hello,

I have 16 classes, each one of them has the attribute (line text) named "Product code" with his identifier product_code

I would like to do the following:

Fetch from node XXX depth 100 all items instances of all the 16 classes that match the criteria "product_code equals to 'text to compare'"

something like this:


{set $newchildren=fetch_alias('children', hash( 'parent_node_id', 172,
                                 depth, 100,
                                'class_filter_type', 'include',
                                'class_filter_array', $newclasses,
                                'attribute_filter',                                    
                                 array( 'or', array('modelo_de_producto/product_code' , '=', "text to compare" ))
                                 ) )}

Being <strong>$newclasses</strong> the names of all the 16 classes.

What I cannot get straight is the

array( 'or', array('modelo_de_producto/product_number' , '=', "text to compare"


As I have always to write the class name plus the attribute, here <strong>modelo_de_producto</strong> is one of the classes to search (one of the 16 classes).

How can I make the fetch for all the 16 classes instances?

Can someone help me please. I am near to my deadline with this!

thanks

Diseño Web Cuba
Web Design Cuba
www.elfosdesign.com

André R.

Sunday 05 October 2008 10:48:39 pm

Attribute filter when used on attribute only works on one class at a time.

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Jorge estévez

Tuesday 07 October 2008 4:34:33 am

Hello,

Thanks for your reply,

ok, made another workaround and solved the problem, thre should be something in the future that could fetch multiple classes comparing one attribute, this could be usefull indeed.

best regards, jorge

Diseño Web Cuba
Web Design Cuba
www.elfosdesign.com

eZ debug

Timing: Jan 20 2025 07:55:57
Script start
Timing: Jan 20 2025 07:55:57
Module start 'content'
Timing: Jan 20 2025 07:55:57
Module end 'content'
Timing: Jan 20 2025 07:55:57
Script end

Main resources:

Total runtime0.1397 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.0066 588.9297180.8438
Module start 'content' 0.00660.0068 769.773493.9609
Module end 'content' 0.01330.1263 863.7344523.7500
Script end 0.1397  1,387.4844 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00352.4906200.0002
Check MTime0.00141.0275200.0001
Mysql Total
Database connection0.00100.691210.0010
Mysqli_queries0.089163.75011410.0006
Looping result0.00100.74101390.0000
Template Total0.126090.210.1260
Template load0.00070.513110.0007
Template processing0.125389.670110.1253
Override
Cache load0.00050.339910.0005
Sytem overhead
Fetch class attribute can translate value0.00070.466710.0007
XML
Image XML parsing0.00020.176110.0002
General
dbfile0.01057.5163200.0005
String conversion0.00000.002930.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.0002 secs