Forums / Developer / "number of days old" in fetch ('content','list') ?

"number of days old" in fetch ('content','list') ?

Author Message

David Zaoui

Thursday 28 June 2007 9:13:12 am

Hi,

I am trying to fetch the articles of some nodes, but with a date constraint : they must have been created less than x days ago ( x being a variable fixed by administrator).
How can i do to obtain the date x days ago from today's date ?
In the fetch("content","search"....) function there is the "publish_date" parameter where you can choose to fetch content which has been published 1day/1week/1month ago.

It's in fact what i want but for the ("content","list") function.
Does this parameter exists?and if not, is it easy to calculate this "publish_date" manually?

Thanks

paul bolger

Thursday 28 June 2007 7:19:10 pm

Assuming you are talking about the publication date take a look at this

http://ez.no/doc/ez_publish/technical_manual/3_9/reference/modules/content/fetch_functions/list#eztoc64251_0_0_1

All time calculations are in Unix time, 86400 seconds in a day, 'now' is currentdate(). For an online converter go to

http://www.esqsoft.com/javascript_examples/date-to-epoch.htm

This should give you "the sum of now and one day is less than the timestamp in the attribute $node.object.data_map.timestamp"

lt (sum ( currentdate (), 86400 ), $node.object.data_map.timestamp ) 

I find that it's often helpful to define variables for subcalculations, $now, $next_week etc as it means a) you can check the output (if {$next_week} doesn't return what you'd expect you can hardly expect anything based on it to be any use), and b) your rules look a lot more like english, and it's much easier to see if the problem is in the code or the logic. I'm not sure what the performance overhead of doing this is though.

Paul Bolger

André R.

Friday 29 June 2007 1:10:31 am

You can it in list / tree fetch as well, but you have to make the attribute filter your self, and it works with unix timestamps as pointed out above.
With attribute filter you can combine several filters to only fetch content within timestamp x and y.

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

eZ debug

Timing: Jan 21 2025 16:12:56
Script start
Timing: Jan 21 2025 16:12:56
Module start 'content'
Timing: Jan 21 2025 16:12:56
Module end 'content'
Timing: Jan 21 2025 16:12:56
Script end

Main resources:

Total runtime0.1769 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.0069 589.2734180.8125
Module start 'content' 0.00690.0112 770.085994.0547
Module end 'content' 0.01810.1587 864.1406526.9063
Script end 0.1768  1,391.0469 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00372.0755200.0002
Check MTime0.00130.7492200.0001
Mysql Total
Database connection0.00050.270810.0005
Mysqli_queries0.108261.18111410.0008
Looping result0.00181.04151390.0000
Template Total0.158289.510.1582
Template load0.00090.494710.0009
Template processing0.157388.962610.1573
Override
Cache load0.00060.350110.0006
Sytem overhead
Fetch class attribute can translate value0.00120.650310.0012
XML
Image XML parsing0.00030.165710.0003
General
dbfile0.022312.6350200.0011
String conversion0.00000.002830.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