Fetch objects published between two dates

Previous topic

Next topic

Author	Message
Eirik Alfstad Johansen	Friday 02 November 2007 2:24:10 am Hi, I'm trying to (3.9.1) fetch a list of objects published between two specific dates. My attribute filter looks like this: array( 'and', array( 'published', '>=', [start_timestamp]), array( 'published', '<=', [end_timestamp])) However, this doesn't give me any nodes. When I try to replace the "and" with an "or", I get all the objects instead. What am I doing wrong? Thanks in advance ! Sincerely, Eirik Alfstad Johansen http://www.netmaking.no/
Julien Plesniak	Tuesday 06 November 2007 7:21:15 am Hello, try with this example: {def $datej = currentdate()} and 'attribute_filter', array(array(186,'<',$datej),array(187,'>',$datej))

Author

Message

Friday 02 November 2007 2:24:10 am

Hi,

I'm trying to (3.9.1) fetch a list of objects published between two specific dates. My attribute filter looks like this:

array( 'and', array( 'published', '>=', [start_timestamp]), 
		array( 'published', '<=', [end_timestamp]))

However, this doesn't give me any nodes. When I try to replace the "and" with an "or", I get all the objects instead.

What am I doing wrong?

Thanks in advance !

Sincerely,

Eirik Alfstad Johansen
http://www.netmaking.no/

Tuesday 06 November 2007 7:21:15 am

Hello,

try with this example:

{def $datej = currentdate()}

and

'attribute_filter', array(array(186,'<',$datej),array(187,'>',$datej))

eZ debug

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0093	588.0469	152.6406
Module start 'layout'	0.0093	0.0041	740.6875	39.4766
Module start 'content'	0.0134	0.0065	780.1641	89.3984
Module end 'content'	0.0199	0.0028	869.5625	30.3047
Script end	0.0227		899.8672

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0028	12.3087	14	0.0002
Check MTime	0.0013	5.9317	14	0.0001
Mysql Total
Database connection	0.0016	6.9147	1	0.0016
Mysqli_queries	0.0049	21.6307	3	0.0016
Looping result	0.0000	0.1142	1	0.0000
Template Total	0.0020	9.0	1	0.0020
Template load	0.0011	4.8397	1	0.0011
Template processing	0.0009	4.1144	1	0.0009
Override
Cache load	0.0008	3.5904	1	0.0008
General
dbfile	0.0016	6.9535	8	0.0002
String conversion	0.0000	0.0566	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

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