Forums / Setup & design / Fetching by Priority

Fetching by Priority

Author Message

Arran Price

Tuesday 18 January 2005 7:24:32 pm

Hi,
Im attempting to fetch articles in a folder via priority and am having no luck.
I have a folder with order based on priority and have assigned all the articles in it to have different priority numbers from 0 through 7. I am getting the articles returned from my fetch, but not in priority order. I cant even figure out what the order is based on (not published date, not priority and not alphabetical). The limit and offset appear to work fine.

Here is the code Im currently trying to use and have tried various other combinations with no luck.

{set news=fetch( 'content', 'list', 
         			hash( 'parent_node_id', $news_node, 
         			      'priority', 'true',
         			      'offset',$offset,
         			      'limit',$limit,
         				 )
			      )    
}

Can anyone see what Im doing wrong here?

Any help greatly appreciated.

cheers

Arran

Eivind Marienborg

Tuesday 18 January 2005 11:41:41 pm

See the examples here: http://www.ez.no/ez_publish/documentation/development/libraries/ez_template/operators/data_fetch

You have to include the sort_by in some way.

Balazs Halasy

Wednesday 19 January 2005 12:13:22 am

Try this:

{set news=fetch( content, list, hash( parent_node_id, $news_node, 
                                      sort_by, array( priority, true ),
                                      offset, $offset,
                                      limit, $limit ) ) }

..and the next time, look up the documentation for this fetch function:
http://ez.no/ez_publish/documentation/reference/data_fetching/content/list

Arran Price

Wednesday 19 January 2005 11:02:21 am

thanks Balazs,
that did the trick.
to note I did spend considerable time in the documentation before posting and must have had the syntax nearly correct in my attempts (my not posting the sort_by code which I had been working on was a copy paste error). Figuring out the exact syntax for the templates has been one of the more frustrating things I have encountered so far with ezpublish.

Oh well I am a beginner with this so am sure will sort it out.

thanks again

Arran

eZ debug

Timing: Jan 31 2025 04:15:17
Script start
Timing: Jan 31 2025 04:15:17
Module start 'content'
Timing: Jan 31 2025 04:15:17
Module end 'content'
Timing: Jan 31 2025 04:15:17
Script end

Main resources:

Total runtime0.1600 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.0061 587.9219180.8438
Module start 'content' 0.00610.0044 768.765697.9766
Module end 'content' 0.01050.1494 866.7422523.0000
Script end 0.1599  1,389.7422 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00332.0893200.0002
Check MTime0.00140.8526200.0001
Mysql Total
Database connection0.00060.361410.0006
Mysqli_queries0.116572.84121410.0008
Looping result0.00140.86571390.0000
Template Total0.149093.210.1490
Template load0.00080.503910.0008
Template processing0.148292.660010.1482
Override
Cache load0.00060.356310.0006
Sytem overhead
Fetch class attribute can translate value0.00080.526410.0008
XML
Image XML parsing0.00030.162410.0003
General
dbfile0.00392.4643200.0002
String conversion0.00000.003130.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