Forums / Setup & design / how to display the articles from the second one?

how to display the articles from the second one?

Author Message

Fiona Hisa

Monday 12 November 2007 7:44:18 pm

hi, everyone

I create a news folder and there are several articles in it. I want to display the articles according to the publish date. but just from the second one, that is doesn't display the latest published article.


    {let children=fetch( content, list, hash( parent_node_id, $node.node_id,
                                        limit, 10,
                                        class_filter_type, include,
                                        class_filter_array, array( 'article' ),
                                        sort_by, array( 'published', false() )
                                        ) )}


what filter should I add?

extended_attribute_filter? 

how to use?

thanks in advance!

Gunnar Birkeland

Monday 12 November 2007 9:24:58 pm

Hi Lost.

Why not make two fetches?

One for the ten latest

{let children=fetch( content, list, hash( parent_node_id, node.node_id, limit, 10, class_filter_type, include, class_filter_array, array( 'article' ),sort_by, array( 'published', false() ) ) )}

And one for the other (based on your sort criteria.)

{let selectedChild=fetch( content, list, hash( parent_node_id, node.node_id, limit, 1, class_filter_type, include, class_filter_array, array( 'article' ),sort_by, array( 'YOURCRITERIA', false() ) ) )}

If the 'selectedChild' exits in the 'children' array you could easily extend the limit by one or exclude the 'selectedChild' from the 'children' search.

gl

</major>
----------------------------
ez-version: 3.9.3.
PHP: 4.4.2-1
MYSQL: 4.0.24

Gunnar Birkeland

Monday 12 November 2007 9:31:12 pm

But hey, why not make it simple.

Ill add this up to the "early morning, cold country" list;)

The use of offset would off course be the best here.

Add

...
'offset', 1,
...

to your fetch (or maybe it should be 2?, not quite sure)

http://ez.no/doc/ez_publish/technical_manual/3_10/reference/modules/content/fetch_functions/list

gl

</major>
----------------------------
ez-version: 3.9.3.
PHP: 4.4.2-1
MYSQL: 4.0.24

Fiona Hisa

Monday 12 November 2007 10:53:52 pm

Thanks a lot!
it works
offset, 1

I am not very sure what is the "offset" exact mean before, hehe.
^_^

paul bolger

Wednesday 14 November 2007 4:10:24 pm

Take a look at this article, actually by Bård Farstad, although for some reason the article list says its by Sandro Groganz.

http://ez.no/developer/articles/building_a_custom_template_for_a_news_portal

Paul Bolger

eZ debug

Timing: Jan 18 2025 14:59:24
Script start
Timing: Jan 18 2025 14:59:24
Module start 'content'
Timing: Jan 18 2025 14:59:24
Module end 'content'
Timing: Jan 18 2025 14:59:24
Script end

Main resources:

Total runtime0.9683 sec
Peak memory usage4,096.0000 KB
Database Queries202

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0072 587.8594180.8125
Module start 'content' 0.00730.8385 768.6719607.0234
Module end 'content' 0.84570.1225 1,375.6953337.3672
Script end 0.9682  1,713.0625 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00390.4006210.0002
Check MTime0.00150.1587210.0001
Mysql Total
Database connection0.00180.183610.0018
Mysqli_queries0.887791.67702020.0044
Looping result0.00210.21412000.0000
Template Total0.938796.920.4694
Template load0.00240.243820.0012
Template processing0.936496.704020.4682
Template load and register function0.00020.021710.0002
states
state_id_array0.00110.113210.0011
state_identifier_array0.00110.117620.0006
Override
Cache load0.00210.2220410.0001
Sytem overhead
Fetch class attribute can translate value0.00140.144340.0003
Fetch class attribute name0.00120.121870.0002
XML
Image XML parsing0.00190.200840.0005
class_abstraction
Instantiating content class attribute0.00000.001880.0000
General
dbfile0.00480.4960330.0001
String conversion0.00000.000630.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
5content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
11content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
5content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
3content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
3content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 29
 Number of unique templates used: 7

Time used to render debug report: 0.0002 secs