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

Next topic

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

Author

Message

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 31 2025 03:31:17
Script start
Timing:	Jan 31 2025 03:31:17
Module start 'layout'
Timing:	Jan 31 2025 03:31:17
Module start 'content'
Timing:	Jan 31 2025 03:31:17
Module end 'content'
Timing:	Jan 31 2025 03:31:17
Script end

Main resources:

Total runtime	0.0220 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0049	588.2656	151.2266
Module start 'layout'	0.0050	0.0033	739.4922	220.7188
Module start 'content'	0.0083	0.0121	960.2109	1,001.9609
Module end 'content'	0.0204	0.0015	1,962.1719	33.9922
Script end	0.0219		1,996.1641

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0027	12.1024	14	0.0002
Check MTime	0.0013	5.9127	14	0.0001
Mysql Total
Database connection	0.0004	1.9409	1	0.0004
Mysqli_queries	0.0021	9.4794	3	0.0007
Looping result	0.0000	0.0358	1	0.0000
Template Total	0.0011	5.0	1	0.0011
Template load	0.0009	3.8947	1	0.0009
Template processing	0.0002	1.1122	1	0.0002
Override
Cache load	0.0006	2.7782	1	0.0006
General
dbfile	0.0003	1.4793	8	0.0000
String conversion	0.0000	0.0326	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs