Forums / Developer / reverse_related_objects multiple categories, IDs or some other solution

reverse_related_objects multiple categories, IDs or some other solution

Author Message

Ivan Švogor

Thursday 04 November 2010 8:21:22 am

Hello,

I've added object relations to my Article class. Now, I can have categories (as is suggested in some manual). And now, I would like to list articles by this relatet object. So I use reverse_related_objects function in my template. And it's ok. It works, I get articles that are in category I want to see. This is controled by object_id parameter.

But now, I have articles that are related to two, or more classes (or categories). Now, I cannot use reverse_related_objects any more becouse object_id parameter is integer, not an array.

My question is how can I get this working. Article with related object class, a few custom classes representing categories, and now I want to list all articles that are related to multiple object, or categories. (I need them to be mixed, becouse list with first category A, than B, than C.. that would be messy)

I would appriciate any ideas or suggestions. Thanks!

Ilya Sazonov

Saturday 06 November 2010 6:09:02 am

The answer is quit using reverse_related_objects . You can use fetch('content','list' ... . But to make it serve your purpose you should use extended_attribute_filter 'ObjectRelation' which can be found in the following extension

http://projects.ez.no/objectrelationfilter

Maybe it's present out of the box now, i'm not sure, read this

http://projects.ez.no/objectrelationfilter/news/moving_objectrelationfilter_from_contribs

My eZpublish version is 4.0.1, so I had to install an extension, but it was worth it.

eZ debug

Timing: Jan 18 2025 10:36:16
Script start
Timing: Jan 18 2025 10:36:16
Module start 'content'
Timing: Jan 18 2025 10:36:17
Module end 'content'
Timing: Jan 18 2025 10:36:17
Script end

Main resources:

Total runtime0.9116 sec
Peak memory usage4,096.0000 KB
Database Queries191

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0077 589.1797180.8047
Module start 'content' 0.00770.7443 769.9844462.7422
Module end 'content' 0.75200.1596 1,232.7266333.4688
Script end 0.9116  1,566.1953 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00410.4476210.0002
Check MTime0.00150.1621210.0001
Mysql Total
Database connection0.00130.138310.0013
Mysqli_queries0.842492.40531910.0044
Looping result0.00200.21541890.0000
Template Total0.882796.820.4414
Template load0.00210.226120.0010
Template processing0.880796.603020.4403
Template load and register function0.00030.028510.0003
states
state_id_array0.00070.075110.0007
state_identifier_array0.00090.093520.0004
Override
Cache load0.00170.1851140.0001
Sytem overhead
Fetch class attribute can translate value0.00170.188930.0006
Fetch class attribute name0.00290.322120.0015
XML
Image XML parsing0.00050.050230.0002
class_abstraction
Instantiating content class attribute0.00000.000720.0000
General
dbfile0.00520.5659210.0002
String conversion0.00000.000730.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
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
2content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
2content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 6
 Number of unique templates used: 4

Time used to render debug report: 0.0001 secs