Forums / Developer / How to fetch content by the custom property in php

How to fetch content by the custom property in php

Author Message

xiaoshitou xiaoshitou

Sunday 21 March 2010 11:46:45 pm

I create a custom class that names "News" and it own a property calls "Date", in tpl, i can fetch the content sort by date as follow:{set $children=fetch( content, list, hash( 'parent_node_id', $object.main_node_id, 'limit', $limit, 'offset', $offset, 'language', $currentlanguage, 'sort_by', array( 'attribute', false(), 'news/date' ) ) ) }but how to fetch it sort by date in php? I try several ways but not correct:$sort = array( 'attribute', true, 'date' );$treeParameters = array ('Offset' => false,'OnlyTranslated' => false,'Language' => $countryCd,'Limit' => false,'Limitation' => null,'class_id' => false,'SortBy' => $sort,'AttributeFilter' => false,'ExtendedAttributeFilter' => false,'ClassFilterType' => "include",'ClassFilterArray' => false,);or$treeParameters = array ( ......'SortBy' => array( 'attribute' => 'News/Date' ),......);or$treeParameters = array ( ......'SortBy' => array ('News/Date','Ascending'),......);Anyone who knows that please help me, many thanks!

Norbert Wagner

Monday 22 March 2010 3:34:03 am

Hi xiaoshitou,
please use code blocks when you write code in the forums.

To your question:

array('SortBy' => array('attribute', true, 'news/date'))

should work.

Not sure if you tried this, though.

Regards,
Norbert

eZ debug

Timing: Jan 18 2025 05:15:28
Script start
Timing: Jan 18 2025 05:15:28
Module start 'content'
Timing: Jan 18 2025 05:15:29
Module end 'content'
Timing: Jan 18 2025 05:15:29
Script end

Main resources:

Total runtime0.8227 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.0081 594.4297180.8125
Module start 'content' 0.00820.6851 775.2422466.2031
Module end 'content' 0.69330.1293 1,241.4453333.4688
Script end 0.8226  1,574.9141 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00430.5265210.0002
Check MTime0.00150.1873210.0001
Mysql Total
Database connection0.00060.076010.0006
Mysqli_queries0.760592.44301910.0040
Looping result0.00180.22011890.0000
Template Total0.791396.220.3957
Template load0.00200.247220.0010
Template processing0.789395.939720.3946
Template load and register function0.00020.021610.0002
states
state_id_array0.00150.181610.0015
state_identifier_array0.00110.133720.0006
Override
Cache load0.00160.1984130.0001
Sytem overhead
Fetch class attribute can translate value0.00110.139430.0004
Fetch class attribute name0.00160.190020.0008
XML
Image XML parsing0.00050.057030.0002
class_abstraction
Instantiating content class attribute0.00000.001620.0000
General
dbfile0.00170.2062210.0001
String conversion0.00000.000830.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
4content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 11
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs